...
| Warning |
|---|
As users can exist at the Database or Server Level. These are two different logins that can have the same or different passwords. |
Users who only need Synergetic Access
Open SQL Management Studio and login as a user who has Server Admin permissions
Creation of a new user
Locate and expand your single database (Database Naming)
...
| Info | ||||||||||
|---|---|---|---|---|---|---|---|---|---|---|
| ||||||||||
With the details entered, ie User Type, User Name, Password. You can select the Script button at the top of the window. This will script out the user creation to a new SQLQuery window if you wish to utilise this for multiple staff, e.g.
|
Modification to an existing user
Locate and expand your single database (Database Naming)
...
| Info | ||
|---|---|---|
| ||
The General page has the users password if this is what you wish to modify  |
Users who need access to other databases on the same SQL Instance
As a contained user, it belongs to the database and you're unable to access resources outside of the database
...
Open SQL Management Studio and login as a user who has Server Admin permissions
Creation of a new user
On the Server level, expand the Security folder
...
| Info | ||||||||||
|---|---|---|---|---|---|---|---|---|---|---|
| ||||||||||
With the details entered, ie Login name, Password and any other information modified in this window. You can select the Script button at the top of the window. This will script out the user creation, along with selected permissions to a new SQLQuery window if you wish to utilise this for multiple staff, e.g.
|
Modification to an existing user
On the Server level, expand the Security folder
...
The Login Properties window will appear where you can make your modifications
Database Service Accounts like SEQTA, Schoolbox or PaperCut
As a contained user, it belongs to the database and you're unable to access resources outside of the database.
Open SQL Management Studio and login as a user who has Server Admin permissions.
Granting access to SQL objects
...