sp_ModifyGroupProperty

Advantage SQL Engine

Sets one property associated with a database user group in the data dictionary.

Syntax

sp_ModifyGroupProperty(

GroupName,CHARACTER,100,

Property,CHARACTER,200,

Value,MEMO )

Parameters

GroupName (I)

Name of the database user group object to set the associated property.

Property (I)

Name of a database user group property to set. See Remarks for allowed values.

Property (I)

Value to be stored in the property.

Special Return Codes

AE_INVALID_OBJECT_NAME

Possible causes for the error is that the pucUserGroupName does not specify a valid user group in the database.

Remarks

sp_ModifyGroupProperty sets one property associated with the specified user group. The new property overwrites the existing property in the data dictionary. The following are the valid values of Property and the expected values.

usPropertyID

Description

COMMENT

Stores a new description for the user group.

Example

After making a connection to the database, store a new description for the user group "Managers".

EXECUTE PROCEDURE sp_ModifyGroupProperty(

‘Managers ‘,

‘COMMENT’,

‘Managers of the Data Product Division.’ );

See Also

sp_CreateGroup

sp_DropGroup

sp_CreateUser

sp_DropUser

sp_AddUserToGroup

sp_RemoveUserFromGroup