Permissions required for WorldServer database users
If you want to run install or upgrade scripts on the WorldServer database as a user that is not a system administrator, you need to grant that user certain permissions. You also need to grant these permissions to database sa users configured for the System Monitor tool.
For Oracle systems
For Oracle systems, make sure that the user has READ rights on the following tables:
- SYS.V_$SESSION
- SYS.V_$LOCKED_OBJECT
- SYS.V_$SQLTEXT_WITH_NEWLINES
- SYS.V_$SQL
- SYS.DBA_OBJECTS
sysdba and run the following commands:
GRANT SELECT ON SYS.V_$SESSION TO <USERNAME>;
GRANT SELECT ON SYS.V_$LOCKED_OBJECT TO <USERNAME>;
GRANT SELECT ON SYS.V_$SQLTEXT_WITH_NEWLINES TO <USERNAME>;
GRANT SELECT ON SYS.V_$SQL TO <USERNAME>;
GRANT SELECT ON SYS.DBA_OBJECTS TO <USERNAME>;
COMMIT;In this case, <USERNAME> is the name of the database user and is provided as an argument to Oracle SQL Developer.
For Microsoft SQL systems
For Microsoft SQL systems, make sure that the user has READ rights on the following tables:
- sys.dm_tran_locks
- sys.dm_os_waiting_tasks
- sys.partitions
- sys.dm_exec_requests
- sys.dm_exec_sessions
- sys.databases
- sys.dm_exec_connections
- sys.dm_exec_query_stats
GRANT VIEW SERVER STATE TO <USERNAME>In this case, <USERNAME> is the name of the database user.