Users
Go Up to Supported Objects
A user is an individual with access to the DBMS.
Creating and editing
- Users Wizard (DB2 LUW) and Users Editor (IBM DB2 LUW)
- Users Wizard (DB2 Z/OS) and Users Editor (IBM DB2 Z/OS)
- Users wizard (MySQL) and Users editor (MySQL)
- Users Wizard (Oracle) and Users Editor (Oracle)
- Users Wizard (SQL Server) and Users Editor (SQL Server)
- Users Wizard (Sybase ASE) and Users Editor (Sybase ASE)
- Note: Creation and editing of objects of this type is not supported against Sybase IQ datasources.
DBMS platform availability and object actions/operations supported
The following table lists object actions available for this object type. For an introduction to object actions and details on usage of specific actions, see Object actions.
| DB2 LUW | DB2 z/OS | MySQL | ORCL | SQL SVR | SYB ASE | SYB ASE | |
|---|---|---|---|---|---|---|---|
|
✓ |
|||||||
|
✓ |
✓ |
✓ |
|||||
|
✓ |
|||||||
|
✓ |
✓ |
✓ |
✓ |
✓ |
✓ |
||
|
✓ |
✓ |
✓ |
✓ |
✓ |
✓ |
✓ | |
|
✓ |
✓ |
✓ |
✓ |
✓ |
✓ |
✓ | |
|
✓ |
| ||||||
|
✓ |
✓ |
✓ |
✓ |
✓ |
✓ |
||
|
✓ |
Navigator Details
Depending on the DBMS platform, the icon associated with a user differs according to the account’s locked or unlocked state, when viewed in the Navigator.
| DBMS Platform | Icon | User Accont State |
|---|---|---|
|
|
Locked | |
|
|
Unlocked |
Microsoft SQL Server Users
Microsoft SQL Server controls access at the database level by requiring the System Administrator or Database Owner to add a login as a database user or alias. After you create a database user, you can implement further security by the granting or revoking the privileges for that user on specific database objects. To consolidate the process of granting or revoking permissions to many users, the database owner can assign users to groups.
MySQL Users
Unlike adding new users to other platforms, MySQL doesn’t rely solely on a userid/password combination. The MySQL server must not only validate the user and password, but also the host from which the connection is being requested before the new user is admitted to the server’s inner sanctum. The User Wizard and User Editor enable these validations.
Oracle Users
To access an Oracle database, you need a user account authenticated with a password. A user account is what Oracle uses to permit access by the user. You can assign the following optional properties to the user:
- Default tablespace
- Temporary tablespace
- Quotas for allocating space in tablespaces
- Profile containing resource limits
Sybase ASE Users
Sybase ASE controls access at the database level by requiring the System Administrator or Database Owner to add a login as a database user or alias. After you create a database user, you can implement further security by granting or revoking the privileges for that user on specific database objects. To consolidate the process of granting or revoking permissions to many users, the database owner can assign users to groups.