| |
Home |
![[Table of Contents]](/dwicons/b_toc.gif)
|
System Administration Guide (Online Only) |
![[-]](/dwicons/i_colpse.gif)
| Chapter 10 Managing Adaptive Server Logins and Database Users |
Chapter 10
This chapter describes methods for managing Adaptive Server login accounts and database users.
| Adding new users: An overview |
| Choosing and creating a password |
| Adding logins to Adaptive Server |
| Creating groups |
|
| Adding users to databases |
![[+]](/dwicons/i_expand.gif)
| Adding a "guest" user to a database |
| Creating visitor accounts |
| Adding remote users |
|
| Number of user and login IDs |
| Limits and Ranges of ID Numbers |
| Login connection limitations |
| Viewing Server Limits for Logins, Users, and Groups |
|
| Creating and assigning roles to users |
|
| Planning user-defined roles |
| Configuring user-defined roles |
| Creating a user-defined role |
| Adding and removing passwords from a role |
| Defining and changing mutual exclusivity of roles |
| Defining and changing a role hierarchy |
| Setting up default activation at login |
| Activating and deactivating roles |
|
| Dropping users, groups and user-defined roles |
| Dropping users |
| Dropping groups |
| Dropping user-defined roles |
|
| Locking or dropping Adaptive Server login accounts |
| Locking and unlocking login accounts |
| Dropping login accounts |
| Locking logins that own thresholds |
|
| Changing user information |
|
| Changing passwords |
| Changing user defaults |
| Changing a user's group membership |
| Changing the user process information |
|
| Using aliases in databases |
| Adding aliases |
| Dropping aliases |
| Getting information about aliases |
|
| Getting information about users |
| Getting reports on users and processes |
| Getting information about login accounts |
| Getting information about database users |
| Finding user names and IDs |
|
| Displaying information about roles |
|
| Monitoring license use |
| How licenses are counted |
| Configuring License Manager to monitor user licenses |
| Monitoring license use with the housekeeper task |
| Logging the number of user licenses |
|
| Getting information about usage: Chargeback accounting |
|
| Reporting current usage statistics |
| Specifying the interval for adding accounting statistics |
|
|