Followup to: GRANTing permissions...

I posted the following article yesterday asking about table references.

==

Howdy,

Yet some more questions from a rookie about putting together an application.

I need to grant permissions on the objects that I have created for a specific application to some users. I know about the GRANT command but it's sorta cumbersome to have to GRANT permissions to each and every user that needs the application. Is there a way to have Oracle use Unix-style groups?

Second question: is it really the case that I have to qualify each and every reference to an object in my application's forms and reports with the creator's (my) ID? If so, why didn't CASE*Generator do that for me? As such, I ended up writing a sed script to prepend my ID to each of my objects and manually wrapped each line of my .inp files at 80 columns. A real bother.
==

I received 3 replies back. The conclusion is:   o set the TABOWN option in CASE*Generator if I want to have the full     reference in the generated forms, reports, et al or   o use a public and/or private synonym for each user or   o use V7's "role" feature

V7's "role" feature sounds like what I really want. I.e., group-like control over access. Can someone who knows a bit more about V7's "roles" explain if it will allow you to control access to objects in a Unix-group-like manner?

George Received on Tue Aug 25 1992 - 22:42:44 CEST