Solved

revoke drop and alter table

Posted on 2001-08-09
2
812 Views
Last Modified: 2010-05-19
I have revoked create table from all schemas but how to revoke alter and drop table. I granted roles connect,resource to schema and revoked create table from them. I grant create table to schema when required. I tried from dba studio but failed. Please help. drop any table and alter any table are the privileges. These are not granted to schema but the guys and gals can alter and drop tables as of now.
0
Comment
Question by:k_murli_krishna
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
2 Comments
 
LVL 3

Expert Comment

by:Wadhwa
ID: 6369373
Hi,
you can not revoke alter and drop table privileges if you login to user account who owns the objects.
suppose emp table are in scott account. you can not revoke drop and alter privilged of emp table from scott account.

if you connect as scott there is no way you can avoid to drop or alter a table owned by scott.

Hope this helps
Sameer

0
 
LVL 3

Accepted Solution

by:
p_yaroslav earned 10 total points
ID: 6371452
Hello!

You cann't revoke these privileges from user, which own this objects, but you can create new schema and create public synonyms on objects to other users. In this case you may fine control access to objects.

Best regards!
Yaroslav.
0

Featured Post

On Demand Webinar: Networking for the Cloud Era

Ready to improve network connectivity? Watch this webinar to learn how SD-WANs and a one-click instant connect tool can boost provisions, deployment, and management of your cloud connection.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Why doesn't the Oracle optimizer use my index? Querying too much data Most Oracle developers know that an index is useful when you can use it to restrict your result set to a small number of the total rows in a table. So, the obvious side…
Truncate is a DDL Command where as Delete is a DML Command. Both will delete data from table, but what is the difference between these below statements truncate table <table_name> ?? delete from <table_name> ?? The first command cannot be …
This video shows how to Export data from an Oracle database using the Datapump Export Utility.  The corresponding Datapump Import utility is also discussed and demonstrated.
This video shows how to configure and send email from and Oracle database using both UTL_SMTP and UTL_MAIL, as well as comparing UTL_SMTP to a manual SMTP conversation with a mail server.
Suggested Courses

624 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question