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

PHP Include w/If IE Condition Statement?
I was having a problem with Internet Exploder (big surprise, right?) displaying my drop down menus i

Converting numbers to months
The porgram works -just need the last function(month_convert_ to convert numbers to months -thanks.

Oracle11g Patch issue
Hi all,

I'm getting the following error while installing Oracle11g Patch 11.1.0.7.0 on IBM-AI

Protecting forms
Alright, I want to protect some forms of mine from SQL Injections, because I had someone earlier spa

Help with some dates
I have a list of dates in an array:

$mondays = array(
strtotime("October 12, 2009

Multiple WHILE loops help
Hi there. I'm writing an application that is pulling and displaying results for real estate listing

New to Arrays
Hi I am new to PHP (a week and a half now) and I am just beginning to read about arrays. I understan

phpMailer will not connect using SMTP
I am trying to use phpMailer with smtp:

Code: [Select]$mailer = new PHPMailer();
$mailer-&

CURL question
i am wondering if it's possible to use multi curl with login something like

login once to web

How to calculate days from variable date?
This will be easy for one of you gurus. I want to fetch the date from a variable date, for example:<