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

private constructor
Hello,

Can we create a constructor as private? If yes, what is the use of it? If no, why can'

Namespace Problem
I'm having problem with a section of code with a variable namespace.

This code works fine:

Help building / using array
First - this is a cross-posting, if this is wrong I apologise! What started out as a MySQL query que

How to get exact 3 moths post date from today date using javascript
How to get exact 3 moths post date from today date using javascript
Please help

How would I protect......
I have a from, actually, a good amount of forms. How can I make it so you can't type the characters:

Character Sets/Collations Stuff
Can someone please give me a check list of things I must do to setup all the charset stuff for my ph

MySQL-PHP Query Results Help
Hello all. I'm hoping to be able to get some help in solving a problem with query/rowcount output. I

'grab_files', multiple extension?
hey guys,

can anyone suggest a way to make to following line of code look for files with more

Need help making a script that moves data into acrhive table
Hi,

I'm kinda new to php/mysql

And i wrote a simple script to store sales lead for a b

SQl num_rows problem
when i try to count rows from an SQL select i get an warning

Code: [Select]$countviews = mysq

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