Reg :- Priviledges

Hi Guys

I have a problem in assigning the priviledges to a user

I have create a user EEIuser and i wanna give rights only to connect and create table not drop table.

But when i have given create session,create table priveldge its allwoing me to connect and create table but its allowing me to drop also the table which i didnt give the user the rights.

How to restrict the user from giving not to drop table priviledge becauz theni grante the drop any table priviledge and revoke still its allwoing me to drop table

Am using oracle 8i

Hi,
When you give a user CREATE TABLE privelege that user will be able to DROP the table as he is the owner of the table.If you want to restrict the user to drop the table you can write a schema level trigger which will restrict to drop the table and this is possible in Oracle 8i

Regards,
Rohit Nirkhe,Oracle DBA,OCP 8i
oracle-support@indiatimes.com

Thanks Rohit

Can you help me in this to write a trigger