Sponsored Links
alter and drop table revoke
alter and drop table revokeI
have granted connect,resource to all my schemas. I am working with
oracle 8.1.6 enterprise edition on windows NT 4. Clients are able to
drop and alter table which I want to prevent. Create table I am giving
to them. Even if I revoke create table, drop and alter is unstoppable.
Please solve this problem.
A:
The
simple way is to create a role that has got only the priviliges you
want to give, and grant that role to the users. (so not connect &
resource.)
connect
= create session, alter session, create cluster, create db link, create
sequence, create synonym, create table , create view.
resource= create: cluster, index, procedure, sequence, table, trigger, type.
what you want is a role that had: create table, create session, (alter session)....
don't forget to give the user some quota to create the tables in.
Page 1
|
| 
