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
You can achieve this if you connect as 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
You can achieve this by running the following command:
GRANT VIEW SERVER STATE TO <USERNAME>
In this case, <USERNAME> is the name of the database user.