Still celebrating National IT Professionals Day with 3 months of free Premium Membership. Use Code ITDAY17

x
?
Solved

revoke drop and alter table

Posted on 2001-08-09
2
Medium Priority
?
815 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 30 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

Free Tool: SSL Checker

Scans your site and returns information about your SSL implementation and certificate. Helpful for debugging and validating your SSL configuration.

One of a set of tools we are providing to everyone as a way of saying thank you for being a part of the community.

Question has a verified solution.

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

Have you ever had to make fundamental changes to a table in Oracle, but haven't been able to get any downtime?  I'm talking things like: * Dropping columns * Shrinking allocated space * Removing chained blocks and restoring the PCTFREE * Re-or…
How to Unravel a Tricky Query Introduction If you browse through the Oracle zones or any of the other database-related zones you'll come across some complicated solutions and sometimes you'll just have to wonder how anyone came up with them.  …
This video shows setup options and the basic steps and syntax for duplicating (cloning) a database from one instance to another. Examples are given for duplicating to the same machine and to different machines
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.

715 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