Granting privileges on table owned by different owner
From: Wade Chy <wchy65_at_yahoo.com>
Date: 15 Sep 2004 16:17:04 -0700
Message-ID: <4fad73ef.0409151517.aa97ebb_at_posting.google.com>
Hi All
I am in a situation where I have to grant select privileges on tables owned by a different owner to a specific role. I am logged in as system/sysdba. I have created a new role FIN_READ_ONLY. I need to grant SELECT privileges on all the existing and future tables owned by FIN. I tried to grant SELECT on FIN.ACCT_REF to FIN_READ_ONLY. But was not successful due to insufficient privileges since SYSTEM does not own the table or dont have grantable on the tables. What will be the best way to grant select on all the existing and future tables not owned by me/system? Do I have to login as the tables owner? Or does all the future tables created by FIN will have to granted individuall? I dont know the password for FIN user. I dont want to change the password because of some application problem. Your help / suggestion will be highly appreciated. TIA Wade Chy Received on Thu Sep 16 2004 - 01:17:04 CEST
Date: 15 Sep 2004 16:17:04 -0700
Message-ID: <4fad73ef.0409151517.aa97ebb_at_posting.google.com>
Hi All
I am in a situation where I have to grant select privileges on tables owned by a different owner to a specific role. I am logged in as system/sysdba. I have created a new role FIN_READ_ONLY. I need to grant SELECT privileges on all the existing and future tables owned by FIN. I tried to grant SELECT on FIN.ACCT_REF to FIN_READ_ONLY. But was not successful due to insufficient privileges since SYSTEM does not own the table or dont have grantable on the tables. What will be the best way to grant select on all the existing and future tables not owned by me/system? Do I have to login as the tables owner? Or does all the future tables created by FIN will have to granted individuall? I dont know the password for FIN user. I dont want to change the password because of some application problem. Your help / suggestion will be highly appreciated. TIA Wade Chy Received on Thu Sep 16 2004 - 01:17:04 CEST