Home » RDBMS Server » Security » Grant/ Revoke permission
Grant/ Revoke permission [message #25602] Thu, 08 May 2003 00:20 Go to next message
vp
Messages: 25
Registered: January 2002
Junior Member
Hi,

I have revoked the create and drop table privileges for a schema. But, I found that the user could still drop the table created in his schema. Why is it so? My goal is to provide the user only with the ability to insert, delete, modify records and alter tables.

thanks.
vp
Re: Grant/ Revoke permission [message #25603 is a reply to message #25602] Thu, 08 May 2003 00:39 Go to previous message
Maaher
Messages: 7064
Registered: December 2001
Senior Member
Look at this thread. In short: a user has implicit rights on his own schema. But in most apps, you use the schema-owner not as an application user, just because to avoid that a user can play around with object structures. Create an application user. Then, create synonyms for all tables you want the application user to access/modify. Grant the proper privileges to the application user.

MHE
Previous Topic: how to revoke privileges for certain objects
Next Topic: DEFAULT ROLE
Goto Forum:
  


Current Time: Sun Sep 26 22:32:07 CDT 2021