There is absolutely no need to grant DBA to that other user. This is very insecure.
As a DBA you should execute the following SQL commands:
Revoke DBA from That_User;
Create Role MyAccount_Read;
Grant Connect to MyAccount_Read;
Create Role MyAccount_Update;
Grant MyAccount_Read to MyAccount_Update;
Grant Select on MyAccount.Table1 to MyAccount_Read;
Grant Select on MyAccount.Table2 to MyAccount_Read;
Grant Insert, Update, Delete on MyAccount.Table1 To MyAccount_Update;
Grant Insert, Update, Delete on MyAccount.Table2 To MyAccount_Update;
Grant MyAccount_Read to User_That_Needs_ReadOnly_Privs;
Grant MyAccount_Update to User_That_Needs_Update_Privs;
Create Public Synonym Table1 for MyAccount.Table1;
Create Public Synonym Table2 for MyAccount.Table2;
>hi
>
>there is a problem in oracle.when i connect to a database containing few tables
>which are in my user account and i want this table to be accessed in different user and he can also view this table and make modification.i have created a user and granted dba to that user with admin option but other user cant see my tables.so plz try to help me out how to solve this problem.
>
>regards,
>
>Thanks in advance
>
>Anuj
Mark McCasland
Midlothian, TX USA