Solved

revoke drop and alter table

Posted on 2001-08-09
2
809 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

Independent Software Vendors: We Want Your Opinion

We value your feedback.

Take our survey and automatically be enter to win anyone of the following:
Yeti Cooler, Amazon eGift Card, and Movie eGift Card!

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…
This post first appeared at Oracleinaction  (http://oracleinaction.com/undo-and-redo-in-oracle/)by Anju Garg (Myself). I  will demonstrate that undo for DML’s is stored both in undo tablespace and online redo logs. Then, we will analyze the reaso…
This video explains at a high level about the four available data types in Oracle and how dates can be manipulated by the user to get data into and out of the database.
This videos aims to give the viewer a basic demonstration of how a user can query current session information by using the SYS_CONTEXT function

763 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