Re: Revoke Create and Alter Table

Buck,

Another option would be to revoke connect from sam. Net effect would be to disallow creating, modifying, or dropping objects in that schema.

It's generally a good practice to not have users connect as the application owner anyway, so a simple grant of sel,ins,upd,del to either a role, or another user should handle access to the table.

Good luck,

JT Received on Wed Feb 16 2005 - 09:33:10 CST