Creates new user IDs and gives permissions to specific users.

Remarks

When granting privileges to groups the same syntax is used, just specify the group name instead of the user name. CREATETAB and LOGIN arguments are extensions to the core SQL grammar. User name and password must be enclosed in double quotes if they contain spaces or other non-alphanumeric characters. Although an optional column list is in the syntax for the INSERT, ALTER, and REFERENCES privileges, the Pervasive.SQL Engine will signal a "not supported" error if any GRANT INSERT, GRANT ALTER, or GRANT REFERENCES statement contains a column list.

The following statement grants all these privileges to dannyd for table Class.

GRANT ALL on Class to dannyd

This statement grants the ALTER privilege to user debieq.

GRANT ALTER on Class to debieq

This example gives INSERT privileges to keithv and miked on table Class.

GRANT INSERT ON Class to keithv, miked

The following statement grants INSERT privileges on two columns, First_name and Last_name, in the person table to users keithv and brendanb

GRANT INSERT(First_name,last_name) ON Person to keithv,brendanb

This example grants CREATE TABLE rights to users aideenw and punitas

GRANT CREATETAB to aideenw, punitas

The next example grants login rights to a user named ravi and specifies his password as 'password'

GRANT LOGIN to ravi:password

This example grants login rights to users named dannyd and travisk and specifies their passwords as 'password' and 1234567 respectively.

GRANT LOGIN to dannyd:password,travisk:1234567

If there are spaces in a name you may use double quotes as in the following example. This statement grants login rights to user named Jerry Gentry and Punita and specifies their password as sun and moon respectively

GRANT LOGIN to "Jerry Gentry" :sun, Punita :moon

This example grants the login rights to a user named Jerry Gentry with password 123456 and a user named travisk with password abcdef. It also adds them to the group pervasive_dev

GRANT LOGIN to 'Jerry Gentry' :123456, travisk: abcdef in group pervasive_dev

Revoke

this statement is the reverse of GRANT SQL statement, it removes the rights for particular user on particular table(s)