DBA_learner
Member
Hello All,
I want to create one user in _user table for odbc access and want to grant permissions similar to one existing user.
Example:-
One user "cust" has read/write permission on multiple tables, now I want to create one new user and want to give similar rights like cust user.
Is there any direct/easy way of doing so rather then checking all permissions of cust user and grant permission to new user for each table manually.
Kindly suggest.
Regards
I want to create one user in _user table for odbc access and want to grant permissions similar to one existing user.
Example:-
One user "cust" has read/write permission on multiple tables, now I want to create one new user and want to give similar rights like cust user.
Is there any direct/easy way of doing so rather then checking all permissions of cust user and grant permission to new user for each table manually.
Kindly suggest.
Regards