Re: revoking drop table priviliege

chandrasekar_at_my-dejanews.com wrote:

> Hi, I have two questions for ORACLE DBA INTELLECTUALS : 1. Is it possible
> to revoke only a drop table priviliege from the user who can connect to
> database, query tables and do transactions . 2. Is it possible to restrict
> a user from dropping and creating tables based on the terminal numbers;
>
> To eloborate the environment , We are running ORACLE 8.0.3.0 in
> winNT platform . We have an user 'test1' where all the other users can query
> this schemas table but the users should not drop or create any tables of their
> own in 'test1'. Particularly the users working in terminal c100,c101,c102 &
> c103 should not be given priviliege for creating or dropping tables .
>
> Your valuable inputs are greatly appreciated .
> thankx in advance
> cheers
> CHANDRASEKAR
>
> -----------== Posted via Deja News, The Discussion Network ==----------
> http://www.dejanews.com/ Search, Read, Discuss, or Start Your Own

HI CHANDRASEKAR,

     If the users are just having "SELECT, UPDATE, INSERT,DELETE"
     object privileges on tables in other people schema , then it should
     solve your problem.  Make sure the users are not having too powerful
     system privileges such as "DROP ANY TABLE" !

John Koo
johnkoo_at_i-wave.net Received on Tue Jan 26 1999 - 05:12:47 CST