Home -> Usenet -> comp.databases.oracle -> Grant privileges to role question ???

Grant privileges to role question ???

From: Tung Nguyen <tung_at_system9.unisys.com>
Date: 1995/08/30
Message-ID: <1995Aug30.145623.24765_at_system9.unisys.com>#1/1 






Hi all,



This is my question. Can someone help me out:



I would like to allow other users be able to look at any
table in my schema so what I am doing is:


	create a role read_all_table;
	grant select on table1 to read_all_table;
	grant select on table2 to read_all_table;


					.....

					.....

	grant read_all_table to user1;
	grant read_all_table to user2;
							.....
							.....
		




The problem is, each time I create a new table I have to do a
grant select on that table to the role read_all_table.



Note that, I don't have privilege to grant select any table.



Is there any other way? or I have to live with that.



Very much appreciated from your help.



Tung Nguyen (tung_at_system9.unisys.com)
Received on Wed Aug 30 1995 - 00:00:00 CEST












Original text of this message