ONLINE HELP
 WINDEVWEBDEV AND WINDEV MOBILE

Help / WLanguage / Managing databases / HFSQL / HFSQL Client/Server functions
  • Retrieving the rights granted to the users and copying these rights
HInfoServerRights (Example)
Retrieving the rights granted to the users and copying these rights
WINDEVWEBDEV - Server codeReports and QueriesWindowsUser code (UMC)Ajax The following example is used to:
  • find out the default rights granted to a user
  • find out the rights actually granted to a user
  • copy the default rights granted to a user to another user
sRights is string
// Retrieves the rights to create the database granted to
// the usernamed Smith on the server of the CNT connection
sRights = HInfoServerRights("CNT", "Smith", hRightsCreateDB)
SWITCH sRights
CASE hAllowed
...
CASE hForbidden
...
CASE hInherit
...
END
END
 
// Retrieve the final rights to create the database
// of the usernamed Smith on the server of CNT connection
sRights = HInfoServerRights("CNT", "Smith", hRightsCreateDB)
SWITCH sRights
CASE hAllowed
  ...
  CASE hForbidden
  ...
  END
END
 
// Copy the rights from a user to another one
sRights1 is string
sRights1 = HInfoServerRights("CNT", "Smith", hRightsCreateDB)
HModifyServerRights("CNT", "Clark", hRightsCreateDB, sRights1)
Minimum version required
  • Version 9
This page is also available for…
Comments
Click [Add] to post a comment

Last update: 05/26/2022

Send a report | Local help