Re: Problem with privileges

->From: goodrich@lynx.larc.nasa.gov (Mike Goodrich) ->Subject: Problem with privileges ->Date: 21 Jan 1994 16:06:33 GMT ->Reply-To: goodrich@lynx.larc.nasa.gov ->Organization: Sun Microsystems, Inc. -> ->Greetings: -> -> I am having trouble providing the proper access privileges to data ->base users. I am creating the database, and granting 'connect' to public. ->But my users get a 'no select permission error' whenever attempting to work, ->and I am having to resort to granting them dba privileges before being ->permitted to work. Even if I specifically grant table level privileges, this ->still does not work, and going into isql and listing the privileges for a ->table does not list any users! I am doing everything that I beleive the ->documentation indicates. Can anyone help? Thanx in advance... -> ->-Mike It sounds like you should do the following: 1. Revoke the user-by-user DBA privileges. 2. For EACH table, grant select to PUBLIC. For each table grant update, insert, delete, etc., as appropriate to individuals who will perform these functions. (Possibly to PUBLIC, but not a good idea in general.) 3. If you are using views, then you must grant permissions at BOTH the table and view level. This might be the source of your problems. Regards, Alan ___________________________ ______________________| R. Alan Popiel |__________________________ \\ Internet: | Martin Marietta, SLS | / \\ alan@den.mmc.com | P.O. Box 179, M/S 3810 | Std disclaimers apply. / )Voice: | Denver, CO 80201-0179 USA | ( / 303-977-9998 |___________________________| (But you knew that!) \\ /________________________) (____________________________\\