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

Is there a quick way to do this?
Hi all,

I need to create a mysql table from php that goes a little something like this

Line break?
Hi, I'm new to the forum and new to php. I'm not sure if I'm using the correct terminology so here i

column name cancatenation within PL/SQL
I have a PLSQL store procedure, and the following statement is part of a subquery
fname||lnam

Binding 2 UDP sockets on same port, connected to different destinations, 1 receives
Hello,
My application wants to send/recv data to 2 different UDP ports on a remote computer, us

Auto-populating dropdowns and multiple forms.
Here's what I have so far:

First drop down = select a state (works)
This populates the sec

need a script for 3 pages
I have a customer who wants me to set up a site with a number of pages with the following requiremen

Using cURL to PUT
Can somebody help with the correct php code to make a cURL PUT request. Here is a sample of code bel

Best way to read this text file.
Hi.I am planning to make a small application in C# to convert the players from Football manager 2010

Working with Dates, help.
Sooo to make a long story short, here's what im trying to accomplish.

I need to create a drop

simple script won't work. Please help
I'm new to php, and I am having trouble displaying a simple script in my web browser. My php code ex

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