This
user should not have to use schema name.objectname and all SELECT qeries run
from APPS user should work from this DB User as well
user should not have to use schema name.objectname and all SELECT qeries run
from APPS user should work from this DB User as well
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