Re: GRANT Help

Chakravarthy Nalamotu (kittu_at_gis.eng.hawaii.edu) wrote:
: The procedure that I follow right now is
: GRANT ALTER, SELECT
: ON owner.object1
: TO role1
: GRANT ALTER, SELECT
: ON owner.object2
: TO role1
 

    As far as I know, U can grant several privileges at once instead of

	granting privileges separately.  U can enter all the privileges
	separated by commas.  Here is the format...

	GRANT ALTER, SELECT
	      ON object1, object2, object3, object4,......         
	      TO role1;

	I know this wud take lot of time, but i guess, this is the only
	way to achieve this...  

	Hope this wud help...

	Cheers

	-Raj