Charles, I do log on as owner Razzak, Is there ever a reason to grant access to the remaining SYS tables?
John -----Original Message----- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of A. Razzak Memon Sent: Friday, October 15, 2004 9:04 AM To: RBG7-L Mailing List Subject: [RBG7-L] - RE: Questions regarding Grant And don't forget the SYS_LABELS3, SYS_LAYOUTS3 and SYS_MERGE tables! Very Best R:egards, Razzak. At 07:35 AM 10/15/2004 -0500, Charlie Parks wrote: >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. >================================================
