Removing a user from the database

To remove a user from your database, we recommend that you contact your DBA. If, however, you need to remove the user yourself, here is a sample set of commands that will remove a user. You need to have DBA privileges to execute these commands.

Executing these commands removes this user entirely from the Oracle or Microsoft SQL Server database instance. The user's access to any other relational data is removed.

In Microsoft SQL Server, this is command:

Use <database>;
exec sp_dropuser '<user_name>';
exec sp_droplogin '<user_name>'; 

where:

• <database> is the name of the database.
• <user_name> is the name of the user you are removing.

In Oracle, this is command:

Drop user <user_name>;

where <user_name> is the name of the user you are removing.

If a user is removed from the database before their role is deleted in Architect, you can and nust remove the user from the application as described in Removing a user's role. This prevents complications that might arise as additional users are added in the future.