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

Help on query replacing the date
Hi Pals,

i want to replace the current date in a column to some value say C or D or any n

PHP Captcha Error help - replace the "die" command
Hi All,

I am after a bit of help with a Captcha spam protection box.

The site gave me

Email/MMS to Site
Hey guys. I'm looking for a way for a user to upload images and/or text via their cell phones. It

Deleting Partners on the Customer Master.
Does SAP handle removing the Partner from Open Sales Orders when a Partner is deleted in the Custome

Map.php
I am a complete beginner to PHP and am looking for some help with a program I am messing around with

captcha error
I have been trying to implement a captcha in php...

here is the code..
Code: (php) [Select

Month String to Numeric?
Hi guys,

Given a month as a string, is there a simple way to find the numeric representation

Amatuer requiring assistance
Beginner and amateur in need of assistance

My Site - (Spare Parts for Domestic Appliances)

Can you help please? Php file
I have to write this php file to allow users to register their nicknames on nickserv

For an I

Trouble with a select list
Hello All!
I was wondering if any of you guys could help me with a small problem I'm having!