Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.server -> Re: revoking drop table priviliege

Re: revoking drop table priviliege

From: Em Pradhan <empradhan_at_dplus.net>
Date: Tue, 26 Jan 1999 07:26:51 -0500
Message-ID: <36ADB48B.253AC918@dplus.net>


Hi

    I hope chanrasekar mentioned that chanrasekar want to revoke drop previledge from the owner of the table/s... I hope there is a way ... didn't strike yet...

    waiting.... for some input..
    thanks
pradhan

John Koo wrote:

> 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 - 06:26:51 CST

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US