Changing user access to Oracle and Structured Query Language server databases

To manage database access for users, you can change their existing access. You can remove rights to objects, and add, delete, or change existing rights.

Before you begin

If you use the IBM® Db2® database platform, you must use IBM Db2 tools to provide database access rights. If you use an application server for authentication and user management, you cannot change database access.

1. In the Users application, open the user for whom you want to change database access.
2. Select the Database Access action.
3. In the Database Access window, remove specific object rights; and add, delete, or change the rows.
4. Click OK.