SQL Server SA/SysAdmin account permissions

Hello Experts,

I need a listing of things I can do with the SA account in SQL Server that cannot be assigned to restricted roles.  My current understanding is that there are certain extended stored procedures that are not available to be run under any other login.
 
Please help
LVL 2
IClownAsked:
Who is Participating?
 
RiteshShahCommented:
Yes, you will be able to do everything with SA and same is true for the user having sysadmin server fixed role, even, if you would like to know the list of permission for the current user, database wide and server wide, have a look at following T-SQL statement.

SELECT * FROM fn_my_permissions(NULL, 'SERVER');
GO
SELECT * FROM fn_my_permissions(NULL, 'database');
GO
0
 
Guy Hengel [angelIII / a3]Billing EngineerCommented:
sa can do EVERYTHING. there is no list to be established.
0
 
RPCITCommented:
as far as I know.. ANYTHING can be assigned to non SA accounts.. but you can't restrict SA at all.

With SQL 2000 you needed SA to install service packs.. but other than that you could do everything under other accounts.  I'm pretty sure that this is fixed with 2005+.
0
 
Guy Hengel [angelIII / a3]Billing EngineerCommented:
with the sysadmin server fixed role, you can do "anything" also, using any account that has that role.
0
 
IClownAuthor Commented:
Thank you to all!  
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.