Re: system privilege granting

From: Joe Brown <joe_at_hopi.dtcc.edu>
Date: 18 Oct 1998 20:52:12 GMT
Message-ID: <70dkds$71g$1@apache.dtcc.edu>

The best solution *IMHO* for many reasons, is to create a seperate instance for testing purposes.

Then you can grant to your harts content w/o concerns of production data.

In article <36297CA5.78E3_at_gpu.srv.ualberta.ca>, Brian Yan <by2_at_gpu.srv.ualberta.ca> wrote:
>I have a test schema called TEST on the database, which contains
>thousands of objects. In the same database, there are some test users as
>well. I want to grant the necessary privilege so that the test users can
>select, update, delete tables. I understant that I can achieve this by
>granting SELECT(UPDATE, DELETE) ANY TABLE to users. However, this would
>allow users to manupulate the table in any schemas. My question is: Is
>there any method that can grant these privelege to specific schema? For
>example: GRANT SELECT ANY TABLE ON schema_name TO user1?
>
>Thank you for your help!
>
>Brian

--
(: Joe Brown :) joe_at_apache.dtcc.edu I believe Wine is going to be great if it ever gets finished. . . I believe Linux _is_ great even though it's not finished! ! ! I believe you have my address. :-) Received on Sun Oct 18 1998 - 15:52:12 CDT