Re: Table permissions

On Mon, 20 Sep 2004 04:50:35 -0400, Dirk Moolman wrote: Define ROLES. Define a role for each set of tied priveleges (ie some users need only SELECT permission on 1/2 the tables, another group SELECT on all tables, still other need INSERT/UPDATE/DELETE permission on certain tables, etc. Grant table/column permissions ONLY to the roles. Drop all user level priveleges on tables, especially PUBLIC. Then you can assign individual users to the proper ROLE to grant the desired set of priveleges with a single GRANT command. Art S. Kagel > I have a dilemma. My database tables belong to lots of different users, > depending if they are in IT, management information, or other departments. > > I need to revoke permissions for a certain user, but also have the user > "public" on my system, which overrides my other usernames. > > This means I have to get rid of user "public", and manage my users > individually. Any suggestions, ideas, comments ? > > > Dirk > > IDS 7.31FD3, Solaris 9 > > > > > > Dirk Moolman > Database and Unix Administrator > MXGROUP > > > "People demand freedom of speech as a compensation for the freedom of > thought which they seldom use." > -Kierkegaard > > > sending to informix-list