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

Thought I has this figured out especially after all the help i received?
Cags, Salathe, Daniel helped me with this yesterday, but not sure i took it all in.
I am attempti

form variables from database help.
Hi all,

I would like to have a form that gives you options based on the results of an mysql q

start new row of pictures
on my site www.budstreasureauctions.com there is a featured auctions box that users will pay to get

path to include folder
Hi everyone,

When I'm testing locally, I have to add the name of the site folder as part of t

Deleting pointers froms vector?
Hi. I have a vector filled with pointers and I want to delete the pointers. I could do a loop and do

mySQL and PHP search
Hello,
I am trying to code a project and ran into a brick wall with one of my pages. I am pretty

explode() function problem maybe
Hi I'm having trouble searching my database. When I type two words in the search field it only searc

weird problem
last time, i did post a topic concerning why my page sometime will load as blank page when using IE.

Saving data from a form into a file
Hey everybody,

Sorry, I am really new to PHP coding and such but a project kind of got thrust

My query is being run with no results.
I have this.

Code: function DropUser($duser_id, $user_email, $user_username) {