Tek-Tips is the largest IT community on the Internet today!
Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!
-
Congratulations Mike Lewis on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
-
Restricting a user in a group
Is it possible to put the one user account in the HR database and "DENY ALL" permissions?- jmickael
- Post #3
- Forum: Microsoft SQL Server: Setup and Administration
-
Restricting a user in a group
I have a windows group assigned to sysadmin. This group, "SQLAdminDB1" has 4 domain users in it. There is a human resourches database on this instance of SQL Server 2000. We want to allow this person to opperate as a DBA but deny ALL access to the HR database. Can I restrict the access of...- jmickael
- Thread
- Replies: 4
- Forum: Microsoft SQL Server: Setup and Administration
