I enabled user privileges in the Server ini file and would like to use them on a per user basis.
I use the SQL methods for granting/revoking privileges,
GRANT READ, INSERT (etc..) on database.* to UserName
REVOKE READ, DELETE (etc) on database.* for UserName
First, is there an API method for doing this through VServer?
Second, is there a way to read the current privilege set to display in an app.
I looked through the docs and couldn't find anything.
Thanks,
Scott