It has been awhile since I have done grant access but I don't recall getting any errors.
Were you logged into the database as owner? I have received similar error messages on different actions when I needed to be logged in as owner and wasn't. -----Original Message----- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of John Engwer Posted At: Friday, October 15, 2004 7:54 AM Posted To: RB7-L Conversation: [RBG7-L] - RE: Questions regarding Grant Subject: [RBG7-L] - RE: Questions regarding Grant Thanks Charles Do you get errors on some tables when you try to Grant privileges? John -----Original Message----- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Charles Parks Sent: Friday, October 15, 2004 8:36 AM To: RBG7-L Mailing List Subject: [RBG7-L] - RE: Questions regarding Grant Along with Sys_forms3 and Sys_Reports3, I usually grant select but no other access on SYS_Tables and SYS_Columns to public. -----Original Message----- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of John Engwer Posted At: Thursday, October 14, 2004 11:07 PM Posted To: RB7-L Conversation: [RBG7-L] - Questions regarding Grant Subject: [RBG7-L] - Questions regarding Grant I am using Grant/Revoke for security on a version 7 database. Here are a couple of questions that I have. 1) Which of the SYS tables do I need to Grant users access to? None of the users develop applications; they are all users. I have assigned access rights to SFS_forms3 and Reports3. 2)When I assign access rights to some tables I get errors but it appears to assign rights anyway. Specified privilege not granted for user xxxxx. (2657) Syntax is incorrect for command return (2045) Even though I get these errors it still assigns the access rights. Any idea why some of the tables get these errors? John --- RBG7-L ================================================ TO POST A MESSAGE TO ALL MEMBERS: Send a plain text email to [EMAIL PROTECTED] (Don't use any of these words as your Subject: INTRO, SUBSCRIBE, UNSUBSCRIBE, SEARCH, REMOVE, SUSPEND, RESUME, DIGEST, RESEND, HELP) ================================================ TO SEE MESSAGE POSTING GUIDELINES: Send a plain text email to [EMAIL PROTECTED] In the message SUBJECT, put just one word: INTRO ================================================ TO UNSUBSCRIBE: Send a plain text email to [EMAIL PROTECTED] In the message SUBJECT, put just one word: UNSUBSCRIBE ================================================ TO SEARCH ARCHIVES: Send a plain text email to [EMAIL PROTECTED] In the message SUBJECT, put just one word: SEARCH-n (where n is the number of days). In the message body, place any text to search for. ================================================
