Albert, I have a RMD program that gives me various levels of access and this what I have used up v10:
GRANT SELECT ON `SYS_Defaults` TO PUBLIC, &vUserList GRANT SELECT, INSERT, UPDATE ON `SYS_Layouts3` TO PUBLIC, &vUserList GRANT SELECT, INSERT, UPDATE ON `SYS_Layouts` TO PUBLIC, &vUserList GRANT CREATE TO PUBLIC, &vUserList Since upgrading to v10 it seems to not be enough so I have resorted to using the database password all the time. Regards, Alastair. On 28/10/2016 16:45, Albert Berry wrote: I need to give users rights using GRANT/REVOKE. I have no problem with the user tables, but I know that certain system tables will require some rights. This is a one computer two user system at the moment. I can use the Utility > Access rights screen once I know which rights to which of the system tables is necessary. Any and all tips greatly appreciated, on or off list. Albert -- You received this message because you are subscribed to the Google Groups "RBASE-L" group. To unsubscribe from this group and stop receiving emails from it, send an email to [email protected]. For more options, visit https://groups.google.com/d/optout.
