select role from DBA_roles;
->Take a backup of the role
-> Drop the role ( Which has the same name as user)
-> Create the user
Note : Roles are not listed in all_objects or dba_objects.
->Take a backup of the role
-> Drop the role ( Which has the same name as user)
-> Create the user
Note : Roles are not listed in all_objects or dba_objects.
No comments:
Post a Comment