User

R12 – Responsibilities not visible to user

Posted on September 4, 2008. Filed under: DBA/Admin Tips, R12, TroubleShooting, User, Workflow Mailer | Tags: , , , , , |

We recently encountered this issue on a R12 instance fully functional instance.

1) Login as sysadmin or any user who as privileges to create user/add responsibilities
2) Create a new user and add responsibilities or add additional seeded/custom responsibilities to existing user

Then,
3) New/existing user logs in but he/she cant see the new responsibility.

Strange isnt it. I had encountered a simillar situation post 11.5.x to 11.5.10.2 upgrade, but the underlying problem is different here.

To tackle this situation, we ran the concurrent program “Workflow Directory Services User/Role Validation” with below parameters:

p_BatchSize – 10000 (Default Value 10000)
p_Check_Dangling – Yes (Default value No)
Add missing user/role assignments – Yes (Default Value No)
Update WHO columns in WF tables – No (Default Value No)

So what does this concurrent program do. It syncs all the user and role related WF tables with latest information viz., WF_LOCAL_ROLES, WF_LOCAL_USER_ROLES, WF_USER_ROLE_ASSIGNMENTS etc.,

The time taken to complete this program depends on the number of users/roles to be synched. After completion of this request the affected user can log back in to see the missing responsibilities.

You can also schedule this request to run every 15 minutes or so, but it depends how frequently you create/assign new users/roles/responsibilities.

cheers,
Ram.

Read Full Post | Make a Comment ( 6 so far )

SQL Script to generate privileges to be granted

Posted on May 29, 2008. Filed under: DBA/Admin Tips, Scripts, User | Tags: , , , |

Imagine you want to grant same exact privileges of existing user A to User B.

Login as a user who has a dba privilege and run below command to generate the list of privileges to be granted.

select
‘grant ‘ || privilege || ‘ on ‘ || owner || ‘.’ || table_name || ‘ to USER B;’
from
dba_tab_privs
where
grantee = upper(‘&GRANTEE_NAME’);

GRANTEE_NAME is USER A.

You can also check this link (https://oraclepitstop.wordpress.com/2008/05/29/sql-script-to-list-oject-privileges-granted-to-a-particular-user/) to list all the privileges granted to a particular user.

cheers,
OraclePitStop

Read Full Post | Make a Comment ( None so far )

SQL Script to list object privileges granted to a particular user

Posted on May 29, 2008. Filed under: DBA/Admin Tips, Scripts, User | Tags: , , , |

Login to database as sys / system / or any user who had dba privileges and run below command

select grantor || ‘ granted ‘ || privilege || ‘ on ‘ || table_name || ‘ owned by ‘|| owner || ‘ to ‘|| grantee
from dba_tab_privs where grantee like upper(‘&GRANTEE_NAME’) order by privilege;

where GRANTEE_NAME is the user you want to find out the privileges.

Even though the view name is dba_tab_privs, it lists privileges on all objects including tables, views, procedures, etc.,

Sample Output

APPS granted DELETE on FND_USER_RESP_GROUPS owned by APPS to XXXXXX
APPLSYS granted DELETE on FND_USER owned by APPLSYS to XXXXXX;

cheers,
OraclePitStop

Read Full Post | Make a Comment ( None so far )

Liked it here?
Why not try sites on the blogroll...