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
Solved

revoke drop and alter table

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

PRTG Network Monitor: Intuitive Network Monitoring

Network Monitoring is essential to ensure that computer systems and network devices are running. Use PRTG to monitor LANs, servers, websites, applications and devices, bandwidth, virtual environments, remote systems, IoT, and many more. PRTG is easy to set up & use.

Question has a verified solution.

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

Suggested Solutions

Working with Network Access Control Lists in Oracle 11g (part 1) Part 2: http://www.e-e.com/A_9074.html So, you upgraded to a shiny new 11g database and all of a sudden every program that used UTL_MAIL, UTL_SMTP, UTL_TCP, UTL_HTTP or any oth…
I remember the day when someone asked me to create a user for an application developement. The user should be able to create views and materialized views and, so, I used the following syntax: (CODE) This way, I guessed, I would ensure that use…
Via a live example, show how to take different types of Oracle backups using RMAN.
This video shows how to Export data from an Oracle database using the Original Export Utility.  The corresponding Import utility, which works the same way is referenced, but not demonstrated.

807 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