Re: Schemas and authorizations

From: Daniel A. Morgan <dmorgan_at_exesolutions.com>
Date: Mon, 07 May 2001 00:51:40 -0700
Message-ID: <3AF6540C.8EC7AAE7@exesolutions.com>

Answers interspersed below:

Daniel A. Morgan

Nuno Souto wrote:

> On 5 May 2001 21:21:21 GMT, "Wolf 'n Pinguin"
> <duif.op.spijkers_at_wxs.nl> wrote:
>
> >
> >I wish to create a user, and allow it SELECT privileges on all tables/views
> >in SCHEMA1 and SCHEMA2, but not on other schemas.
> >
>
> Grant the privileges to a role, then grant the role to the user.
> You realize of course that if the schemas are identical, the user will
> have to refer to objects in them by "schema_name.object_name", don't
> you?

But of course. Though synonyms could easily be created to, for example, make the persons table the "xpersons" table" shortening the amount of time spent writing the other schema name.

> You can use PL/SQL to create the grant statements, or just use SQL
> itself in SQL*PLus to generate them. If you don't know how to do
> this, then I'm sure a lot of others here will be able to help you with
> that.
>
> Cheers
> Nuno Souto
> nsouto_at_bigpond.net.au.nospam
> http://www.users.bigpond.net.au/the_Den/index.html
Received on Mon May 07 2001 - 02:51:40 CDT