create user account
-
Hi everyone! How do I grant a server role permission to create users? I previously added database administrators to the 'sysadmin' server role and they were able to create users. I also changed the schema of my tables but now the schema for the 'sysadmin' role cannot be changed from 'dbo' to the one I created. One way to let them access tables is to prefix my tables with the schema name but there are lots and lots of code to do this. I moved the administrators to the 'securityadmin' server role and they are able to use tables without prefixing table names with the schema name. But now they are only able to create logins but cannot create users as an error is reported that the user does not have permission to do it. I would like to know how I can grant the 'securityadmin' role permission to create users so that I will not have to prefix my table names with the schema name if they should remain in the 'sysadmin' role as editing the code at this point for this will likely cause problems. Thanks in advance.
-
Hi everyone! How do I grant a server role permission to create users? I previously added database administrators to the 'sysadmin' server role and they were able to create users. I also changed the schema of my tables but now the schema for the 'sysadmin' role cannot be changed from 'dbo' to the one I created. One way to let them access tables is to prefix my tables with the schema name but there are lots and lots of code to do this. I moved the administrators to the 'securityadmin' server role and they are able to use tables without prefixing table names with the schema name. But now they are only able to create logins but cannot create users as an error is reported that the user does not have permission to do it. I would like to know how I can grant the 'securityadmin' role permission to create users so that I will not have to prefix my table names with the schema name if they should remain in the 'sysadmin' role as editing the code at this point for this will likely cause problems. Thanks in advance.
The type of the database (and the version) is essential when asking this level of information as the security functionality varies between database systems.
Never underestimate the power of human stupidity RAH
-
The type of the database (and the version) is essential when asking this level of information as the security functionality varies between database systems.
Never underestimate the power of human stupidity RAH