| Update role [message #115095] |
Thu, 07 April 2005 08:06  |
ntnboi
Messages: 17
Registered: April 2005
Location: Italy - Rome
|
Junior Member |
|
|
Hi,
I have follow question.
USER A
USER B
I want that user A can select all tables of user B
for make this:
1. - create a rule ROLE_SEL_USER_A;
2. - add role ROLE_SEL_USER_A to user A;
3. - execute follow script
set pages 0
set linesize 120
spool creatre_grant_select_user_A.sql
SELECT 'GRANT SELECT ON B.'||OBJECT_NAME|| ' TO ROLE_SEL_USER_A;'
FROM DBA_OBJECTS where owner='B' and object_type='TABLE';
spool off
4. - launch creatre_grant_select_user_A.sql by user B.
User A now can select all tables of user B, but if user B create a new table, user A do not select this new table.
I make steps 3,4 every time user B create a new table? Or is possible create a role outoupdating?
Thank you.
Best regards.
Antonio.
|
|
|
|
|
|
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
