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.
Did you know?Explore Trending and Topic pages for more stories like this.

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,
No comments posted yet

Your Answer:

Login to answer
236 Like 48 Dislike
Previous forums Next forums
Other forums

PHP Array quick help
I need

$_SESSION{'username'} to be like this:


if $_SESSION['username'] = "gay

SCO Unix
I know this might not be the place to ask, but, can anyone tell me if SCO Unix comes with PHP built

type check while uploading
Hi Everyone,

How can I check the exact type of a file while uploading on my site?

Here

Call to undefined function mysql_fetch_accoc()
New to php/mysql coding. What's wrong with this sequence, or am I
just not seeing to obvious?

Help with syntax
Hi all!

The $bridge variable is not getting passed while it is contained in the line below:

Contents of variable not echoing
Hey guys, hopefully this is an easy one...

In this line, the variables are not echoing out. T

Image DPI
Hi.

I allow users to upload images, the user then is able to adjust several settings for the

limitations on array_unique()
Does any one know what/how imitations are applied to array_unique? I have an issue where no matter h

phpMailer not working ..........
HI,
I was playing with the phpMailer script and tried to send a smiple mail using their test scri

database design
Hi,

I got a page which allow candidate to type in their previous working experience,
I let

Sign up to write
Sign up now if you have flare of writing..
Login   |   Register
Follow Us
Indyaspeak @ Facebook Indyaspeak @ Twitter Indyaspeak @ Pinterest RSS



Play Free Quiz and Win Cash