Revoking alter any table from a schema

Posted on 16th Feb 2014 07:03 pm by admin

Hi All,

i am working in Oracle 10g.
my requirement is to revoke all kind of DDL operations(except creating procedure etc) from a schema or user. for this i have revoked all the roles and system privileges from a schema.

Now my schema has following privileges only:
1. CHANGE NOTIFICATION
2. CREATE PROCEDURE
3. CREATE SESSION
4. DEBUG CONNECT SESSION

Now i am not able to create any table which is fine but still i am able to alter table which i do not want.
can you suggest where i need to check, what can be missing which i am not able to find till now.

Thanks in advance,

Your Answer:

Login to answer

Other forums

PHP Blog help
Need help with posting comments in a word press blog? I have a comments page where the comments are

Table control is disappearing from Screen
Hi Experts,

I have a screen with multiple table control(TC). Each table control has two c

Can't shake the "Warning: include()" error
I've just uploaded my site to a new server and where I have PHP include tags in my HTML, the browser

extract data
Code: <div class="post hentry uncustomized-post-template">

What's wrong with my code
sobbing for many days, still don't know why please Help. Why my page isn't posted correctly. In a

php form help
Hey,

I use a control file to set my meta tags and titles

Here's an example
Code: &a

AutoChoosing a CSS file based on URL
Hey everyone,

I have a site that has multiple URLs and CSS files.

Based on the URL tha

Random Number Generation And Probability
Hello, I am working on a function which has to insert data into a SQL table.

we have to suppl

! = ''
In the following 'IF' statement if v_ompcat = PU for example then Oracle equates that 'IF' statement

how to validate date using javascript
I need to validate date in textbox using javascript..
The date is must be not greater than TODAY