User Roles
- Last UpdatedMar 14, 2024
- 2 minute read
Refer to the table for the server roles and database rights for respective P&ID Users.
|
System Administrator |
Drawing Manager |
Designer |
Drawing User |
|
|---|---|---|---|---|
|
Server Roles |
Dbcreator |
Public |
Public |
Public |
|
Public |
||||
|
User Mapping role at Database Level |
Public |
Public |
Public |
Public |
|
Db_Dbowner |
Db_datawriter |
Db_datawriter |
Db_datawriter |
|
|
Db_datawriter |
Db_datareader |
Db_datareader |
Db_datareader |
|
|
Db_datareader |
Note: Users with system administrator rights can perform a copy project.
Note: For a windows user not logged in using the SQL server, an entry is created in the users table (admin database) with a role of drawing user.

The system administrator server roles assigned to the selected login are shown.

Note: For any user other than a system administrator, only the public server role is assigned.
The assigned user mappings correspond to Database-73191 (this is the same as the Reports and Admin databases).

Note: For any user other than a system administrator, only the following roles are assigned:
-
Db_datareader
-
Db_datawriter
-
Public