Logins
Go Up to Supported Objects
Logins let you access your account. Your login account controls access to the server and all of the databases within it. Only the System Administrator or System Security Officer can create logins. Once you can log into a server, you need additional privileges to access user databases. Specifically, each database owner adds the login as a user or alias to the database.
Contents
Creating and editing
- Logins Wizard (SQL Server) and Logins Editor (SQL Server)
- Logins Wizard (Sybase ASE) and Logins Editor (Sybase ASE)
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.
SQL SVR | SYB ASE | |
---|---|---|
✓ | ||
✓ | ||
✓ |
||
✓ |
||
✓ |
✓ | |
✓ | ||
✓ |
✓ | |
✓ |
✓ | |
✓ |
✓ | |
✓ |
Depending on the DBMS platform, the icon associated with a login differs according to the login’s locked or unlocked state, when viewed in the Navigator/Explorer.
DBMS Platform | Icon | Login Accont State |
---|---|---|
Locked | ||
Unlocked |
DBMS-specific notes
Microsoft SQL Server Logins
Logins let you access your account. Your login account controls access to the server and all of the databases within it. Only the System Administrator or System Security Officer can create logins. Once you can log into a server, you need additional privileges to access user databases. Specifically, each database owner adds the login as a user or alias to the database.
Sybase ASE Logins
Logins let you access your account. Your login account controls access to the server and all of the databases within it. Only the System Administrator or System Security Officer can create logins. Once you can log into a server, you need additional privileges to access user databases. Specifically, each database owner adds the login as a user or alias to the database.