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
WINDEVWindowsUser code (UMC) 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