|
All new users are automatically granted the PUBLIC system role.
You can control the privileges granted automatically to new users by editing the privileges included in the PUBLIC role.
By default, the privileges assigned to new users include:
The ability to connect to the database (assuming a password has been specified for the user).
The ability to view the data stored in the system views.
The ability to execute most system stored procedures.
Once you have created a new user, you can:
Grant system roles and system privileges to the user.
Set the user's object-level privileges.
Assign a login policy to the user. By default, a user is assigned to the root login policy.
Set the user as the publisher or as a remote user of the database for use in a SQL Remote system.