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

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 -- Received on Thu Aug 11 2005 - 08:22:23 CDT