a.
Create
a user using
Create
a user using
Create user
‘username’ identified by ‘password’;
‘username’ identified by ‘password’;
b.
Then
execute the following command in the sql prompt as the sys user,
Then
execute the following command in the sql prompt as the sys user,
spool
create_grants.sql
create_grants.sql
set echo off
set pagesize 0
set linesize 300
set feedback off
SELECT ‘Grant
select on APPS.’||object_name||’ to A;’ FROM user_objects WHERE object_type IN
(‘TABLE’,’VIEW’);
select on APPS.’||object_name||’ to A;’ FROM user_objects WHERE object_type IN
(‘TABLE’,’VIEW’);
spool off;
exit;
c.
Executing
the script would create a sql file name
create_grants.sql that has all the ‘SELECT priveleges’ of all the objects that
the APPS user has access to..
Executing
the script would create a sql file name
create_grants.sql that has all the ‘SELECT priveleges’ of all the objects that
the APPS user has access to..
d.
Finally
run the create_grants.sql script.
Finally
run the create_grants.sql script.
Recent Posts