| Grant/ Revoke permission [message #25602] |
Thu, 08 May 2003 00:20  |
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  |
 |
Maaher
Messages: 7065
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
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
