Re: "grant select" for all tables: Is it possible?

On 11 Aug 2005 06:22:23 -0700, "Mark D Powell" <Mark.Powell_at_eds.com> wrote:

>If user B is the only other user you will want to see all of A tables
>then each time you create a user A table (or tell user A to) issue a
>grant select on the new table to B.
>
>But if you think that you might want user C to also see these same
>table then create a role, readA. Each time you or user A creates a
>table a grant should be done to the role readA and you can then grant
>the role to user B, C, and any others in the future that need to read
>user A's tables.
>
>If you really want to make the grant automatic you can write a database
>DDL event trigger and when the user is A use an execute immediate to
>perform the grant to B. I am not really sure this is such a great idea
>but it would automate the process.
>
>HTH -- Mark D Powell --

I've tried this a while ago (9i). This action is not allowed by Oracle.

Jaap. Received on Thu Aug 11 2005 - 12:41:00 CDT