----------------------------------------------------------- New Message on MumbaiUserGroup
----------------------------------------------------------- From: Star_Venkat Message 1 in Discussion Revoke: To rollback the deny statements we have to use revoke statement. This guy will take care of removing the granted and also denied permissions for the specified user in the current database. The syntax is, Revoke "Particular statement or multiple statements" from "Particular User"or "Multiple User" Example: REVOKE CREATE TABLE FROM VENKAT Now, considering i have been denied to create tables in that particular database. In that case, this above statement will remove the restriction on that particular database for that particular user. REVOKE CREATE TABLE,CREATE DATABASE FROM VENKAT,ARUN Statement with multiple command for multiple users. A small change in the revoke syntax for select statement restricitons, REVOKE SELECT ON VenkatTable TO ARUN Arun user doesn't have access to this particular table, am trying to recover this restriction for that particular user. Regards, Venkatesan Prabu. J ----------------------------------------------------------- To stop getting this e-mail, or change how often it arrives, go to your E-mail Settings. http://groups.msn.com/MumbaiUserGroup/_emailsettings.msnw Need help? If you've forgotten your password, please go to Passport Member Services. http://groups.msn.com/_passportredir.msnw?ppmprop=help For other questions or feedback, go to our Contact Us page. http://groups.msn.com/contact If you do not want to receive future e-mail from this MSN group, or if you received this message by mistake, please click the "Remove" link below. On the pre-addressed e-mail message that opens, simply click "Send". Your e-mail address will be deleted from this group's mailing list. mailto:[EMAIL PROTECTED]
