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 FTP connect doesn't work with correct login
Hi!

i am working on this test code:
Quote<?php

$ftp_ser

problem when runing a funciton
I am trying to connect to database using a funciton in a functions.php

<?php
funct

Display certain image depending on time of year
Hi, I am new to these forums and would really appreciate some advice on a piece of coding I have don

Storing/displaying image urls in a database?
Hi
Basically I have the following scenario:
User chooses picture from list. Picture info is ad

$_FILES array
Ok,

I just started experimenting with PHP today. My goal right now is to have people be able

All possible combinations of Strings from table in PL/SQL
Hi,

I am trying to figure out how to build a list of all possible string combinations fro

Beginner question regarding Array's
Hi everyone, the page im working on has an array of variable at the top...

Code: $define_li

why this query can delete duplicates ?
why this query can delete duplicates ? Anybody can give me the detailed explanation ?

Tha

Grabbing Values From an Array for Posting
I have a grid array that I am using with a form that when it hits the currently named test.php it lo

Ajax Error since Upgrading to 3.5
Ever since upgrading my site to .NET 3.5 (I needed LINQ), I've been getting this annoying error on o

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