Tips
Umlauts/UTF-8
Normalization
OemToAnsi
MySQL Import
Site Search
City Desk
DynDNS
MXLookup
SPAM
Support
Downloads
Contact Us
Access Control
User rights are maintained by table admin. Column PERMISSION contains all tables visible to the appropriate user and column RIGHTS defines what the user is allowed to do with tables visible to him. On the first view column admin.RIGHTS just contains the group the user belongs to.
Operation allowed for a certain group are contained in table rights. Pre defined groups are Guest, Operator and Administrator.
Operations allowed to group Operator are dedicated for typical data maintenance operations: Insert, Update and Delete.
In terms of SqlDBU functions possible operations have to interpreted as follows:
SqlDBU Function DBRIGHTS Value View data Select Edit Record Update Append Record Insert Delete Record Delete Change Structure Alter Create New Table Create Delete Table Drop
If pre defined user groups Administrator, Operator, Guest and their rights are not sufficient enough for your purpose feel free to define a new group with the desired combination of SQL permissions and assign the newly defined group to the appropriate user(s).
