Kbase P49612: How to grant SELECT SYSTEM OBJECTS to ORACLE user?
| Autor |
Progress Software Corporation - Progress |
| Acesso |
Público |
| Publicação |
28/10/2003 |
|
Status: Unverified
GOAL:
How to grant SELECT SYSTEM OBJECTS to ORACLE user?
GOAL:
How to grant permissions to an ORACLE user via command line/SQLPLUS?
FIX:
GRANT SELECT ON "SYS"."TABLE" TO "<USER>";
i.e.,
GRANT SELECT ON "SYS"."ARGUMENT$" TO "SCOTT";
GRANT SELECT ON "SYS"."COL$" TO "SCOTT";
GRANT SELECT ON "SYS"."COM$" TO "SCOTT";
GRANT SELECT ON "SYS"."CON$" TO "SCOTT";
GRANT SELECT ON "SYS"."DUAL" TO "SCOTT";
GRANT SELECT ON "SYS"."ICOL$" TO "SCOTT";
GRANT SELECT ON "SYS"."IND$" TO "SCOTT";
GRANT SELECT ON "SYS"."LINK$" TO "SCOTT";
GRANT SELECT ON "SYS"."OBJ$" TO "SCOTT";
GRANT SELECT ON "SYS"."PROCEDURE$" TO "SCOTT";
GRANT SELECT ON "SYS"."SEQ$" TO "SCOTT";
GRANT SELECT ON "SYS"."SYN$" TO "SCOTT";
GRANT SELECT ON "SYS"."TAB$" TO "SCOTT";
GRANT SELECT ON "SYS"."USER$" TO "SCOTT";
GRANT SELECT ON "SYS"."VIEW$" TO "SCOTT";