<Connection variable>.AddGroup (Function)

ONLINE HELP
WINDEV, WEBDEV AND WINDEV MOBILE

Version:

Home | Sign in | English

Help / WLanguage / Managing databases / HFSQL / HFSQL Client/Server functions

Rights required to add a user group
Rights management

WINDEV

WEBDEV

WINDEV Mobile

Others

See also

<Connection variable>.AddGroup (Function)

In french: <Variable Connexion>.AjouteGroupe

Available only with this kind of connection

Adds a group of users. All the group characteristics must be specified in the variables for group management.

Example

// Describe the connection
MyConnection is Connection

// Describe the connection
MyConnection.User = "USER"
MyConnection.Password = "PASSWORD"
MyConnection.Server = "MYSERVER" 
MyConnection.Database = "Database"
MyConnection.Provider = hAccessHFClientServer
MyConnection.Access = hORead


// Open the connection
MyConnection.OpenConnection()
// Associate the data file with the connection
Customer.ChangeConnection(MyConnection)
// Characteristics of the new group
HGroup.Name = "ADMIN2"
HGroup.Description = "Database administrators"
HGroup.Users = "Flo" + CR + "Julia"
// Add the group
IF MyConnection.AddGroup() = True THEN
	Info("Group added")
END

Syntax

<Result> = <Connection>.AddGroup()

<Result>: Boolean

True if the group has been added,
False if an error occurs. HError is used to identify the error.

<Connection>: Connection variable

Name of the Connection variable that describes the connection to which the group of users must be added.

Remarks

Rights required to add a user group

To add a user group, you must have the following rights:

Rights to manage the users (hRightsManageUser constant).
Rights to see the users (hRightsSeeUser constant).

These constants are used in <Connection variable>.InfoServerRights and <Connection variable>.ModifyServerRights.

Rights management

No rights are granted to a new group.

The following function are used to grant rights to a group:

<Connection variable>.ModifyDatabaseRights: is used to grant rights on a database.
<Connection variable>.ModifyFileRights: is used to grant rights on a data file.
<Connection variable>.ModifyServerRights: is used to grant rights on a server.

For more details, see Managing the rights in HFSQL Client/Server.

Component: wd300hf.dll