Still celebrating National IT Professionals Day with 3 months of free Premium Membership. Use Code ITDAY17

x
?
Solved

SysAdmin Role and Groups

Posted on 1999-07-12
2
Medium Priority
?
1,018 Views
Last Modified: 2008-02-20
I have groups created in NT, and set up in SQL 7.  Can I set a group as SysAdmin Role for just a particular database?  Or, does the SysAdmin Role remain for any database the group has access to?

What suggestions would you have to limit the Group's SysAdmin rights in other databases?

Any suggestions/solutions are appreciated!
0
Comment
Question by:jhoran
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
2 Comments
 
LVL 5

Accepted Solution

by:
Mujeeb082598 earned 400 total points
ID: 1096343
Hi :)

Sysadmin is not a database level role, it is a server wide role and any member of this role can do any thing server wide.

U can use the db_owner or the db_dlladmin role of individual databases to administer that particular database.

db_onwer role has all permissions in the database and db_dlladmin role can issue ALL DDL (data defination language statements like create, alter, drop), but cannot issue GRANT, REVOKE, or DENY statements, for these u can use the db_securityadminrole which can manage all permissions, object ownerships, roles and role memberships.

If your requirement is that user should admin whole thing in a particular database then add that user or group to db_onwer fixed database role.

Hope this help and give u insight.
0
 

Author Comment

by:jhoran
ID: 1096344
Thanks for your help!
0

Featured Post

How Blockchain Is Impacting Every Industry

Blockchain expert Alex Tapscott talks to Acronis VP Frank Jablonski about this revolutionary technology and how it's making inroads into other industries and facets of everyday life.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

In the first part of this tutorial we will cover the prerequisites for installing SQL Server vNext on Linux.
It is possible to export the data of a SQL Table in SSMS and generate INSERT statements. It's neatly tucked away in the generate scripts option of a database.
Familiarize people with the process of utilizing SQL Server functions from within Microsoft Access. Microsoft Access is a very powerful client/server development tool. One of the SQL Server objects that you can interact with from within Microsoft Ac…
This videos aims to give the viewer a basic demonstration of how a user can query current session information by using the SYS_CONTEXT function

670 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question