-----------------------------------------------------------
New Message on MumbaiUserGroup
-----------------------------------------------------------
From: Star_Venkat
Message 1 in Discussion
Deny:
On security part, sql server holds an add on feature called Deny. It enables
the administrator to control a particular group members or particular role
memberships to execute a statement.
The syntax is,
Deny statement to account
Example:
DENY CREATE TABLE, CREATE DATABASE
TO VENKAT
In the above statement i am trying to restrict the user venkat to create the
database and to create the table in the server. For executing the above query
we should have dbo rights.
DENY CREATE TABLE TO MGMTMEMBERS
In the above statement creating table should be restricted for the Management
Members role. 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]
