Granting SELECT permissions to a user based

From: Abdul Aleem <abchaudhary-ho_at_beaconhouse.edu.pk>
Date: Mon, 29 May 2000 16:46:18 +0500
Message-Id: <10512.107011@fatcity.com>

-----Original Message-----

From:	Abdul Aleem 
Sent:	29 May, 2000 4:37 PM
To:	Abdul Aleem
Subject:	RE: Granting SELECT  permissions to a user based

Dear ONE,

To my understanding there is no Schema privileges (directly) you can grant object and system privileges.
You cannot perhaps GRANT SELECT ON ANY TABLE TO ... either. What you can do is create a role with the tables of your schema, or create PL/SQL block that would pick up table names from the Main Schema, and a loop will grant the privileges to the said user.

HTH! Aleem

				-----Original Message-----
				From:	Andreas Jung [mailto:ajung_at_sz-sb.de]

<mailto:[mailto:ajung_at_sz-sb.de]>

                                Dear all,

                                I have a schema MAIN that holds all my tables. I want to create

                                a user U that should have only SELECT permissions on the complete

                                schema MAIN. How can I grant these
permissions to the user without

                                granting SELECT permission on every table of MAIN.* ?                                 Andreas

				-- 
				Author: Andreas Jung
				  INET: ajung_at_sz-sb.de

Received on Mon May 29 2000 - 06:46:18 CDT