How can i Deny access to my domain users to my sql databases and grant acces
s
only to some users. If a make Deny to all users in domain and if a create th
e
necessary users with Grant Access to some databases, the can access the
databases?
Best RegardsCreate a group and add the users you want tio deny access
Take a look at below stored procedure in the BOL.
sp_revokedbaccess [ @.name_in_db = ] 'name'
"icrp@.msn.com" <icrpmsncom@.discussions.microsoft.com> wrote in message
news:9F945ED7-1C19-44CC-A15E-C44D30CCEB65@.microsoft.com...
> How can i Deny access to my domain users to my sql databases and grant
> access
> only to some users. If a make Deny to all users in domain and if a create
> the
> necessary users with Grant Access to some databases, the can access the
> databases?
> Best Regards|||Hi,
what happen if you create seprate user and assign each of them a
permissions , it will be hectic if # users are large , rather if you create
a
ROLE(department wise) and then assign them a proper permissions and then map
a user / group ( it could be sql or windows user/group) . it will save your
time and purpose tooo.
HTH
Regards
--
Andy Davis
Activecrypt Team
---
SQL Server Encryption Software
http://www.activecrypt.com
"Uri Dimant" wrote:
> Create a group and add the users you want tio deny access
> Take a look at below stored procedure in the BOL.
> sp_revokedbaccess [ @.name_in_db = ] 'name'
>
> "icrp@.msn.com" <icrpmsncom@.discussions.microsoft.com> wrote in message
> news:9F945ED7-1C19-44CC-A15E-C44D30CCEB65@.microsoft.com...
>
>
Subscribe to:
Post Comments (Atom)
No comments:
Post a Comment