Kbase P49614: Does Progress provide a simple SQL script that can be provid
| Autor |
Progress Software Corporation - Progress |
| Acesso |
Público |
| Publicação |
28/10/2003 |
|
Status: Unverified
GOAL:
Does Progress provide a simple SQL script that can be provided which lists all the ORACLE permissions needed to run Progress-to-ORACLE utlity?
FIX:
No Progress does not provide a SQL script on this matter, however here is an example of the SQL syntax that can be used. The followng sample syntax will;
1. Create a user and define a password for user.
(In this case, user and password is the same, SCOTT)
2. Grant System Privilegs to user
3. Grant Object Privilegs to user
4. Grant QUOTA for default tablespace to user; SYSTEM is default tablespace
CREATE USER SCOTT IDENTIFIED BY SCOTT;
GRANT CREATE SEQUENCE to SCOTT;
GRANT CREATE SESSIONS To SCOTT;
GRANT CREATE TABLE to SCOTT;
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";
GRANT SELECT ON "SYS"."TS$" TO "SCOTT";
GRANT "CONNECT" TO "SCOTT";
alter user "SCOTT" quota unlimited on SYSTEM;