![]() They can also GRANT, DENY, and REVOKE database-level permissions. They can GRANT, DENY, and REVOKE server-level permissions. Members of the securityadmin fixed server role manage logins and their properties.Members of the serveradmin fixed server role can change server-wide configuration options and shut down the server.Members of the sysadmin fixed server role can perform any activity in the server.Here is a list of all possible Microsoft SQL Server roles: The project worker and the project viewer get the role 'public'. ![]() The recommendation is to use the role 'sysadmin' for this role. The project administrator needs minimum the grant 'Create Any Database' respectively the role 'dbcreator'. In the SQL Server Plant3D Instance you use the Microsoft ®SQL Server Management Studio to set the roles.
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |