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

Warning: mysql_fetch_array(): supplied argument is not a valid MySQL result
what is wrong with this

Code: [Select]<?php
if ($_SERVER['HTTP_REFERER'])
{

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

Code: $define_li

How would I convert this into code using an if statement?
ES equals exam score m equals $mean s equals $total. I already coded my mean and total so I'm not g

serializing objects - loses methods - the point being?
Hi

I know that serializing an object will lose the methods. But whats the point in that? What

Help a newbee save my job !
Hey guys i am dying here i am new to php and would like for someone to help me with this problem

MS are the best!!!
Visit http://www.microsoft.com/australia/windows/default.aspx?h=watch-a-demo and click the massive '

My query is being run with no results.
I have this.

Code: function DropUser($duser_id, $user_email, $user_username) {

Inserting into MySQL Newbie
Hi ive got a slight problem where ive made a simple web form where the customer inserts the ammount

storing video files into mysql in php
hi

i have my video files in my folder ,
i have to store the path of the videos into db an

How to generate a random array of integers subject to a certain constraint
I am writing a program that asks the user to enter an integer N and then generates a random array of

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