Sybase Adaptive Server Anywhere - GRANT Statement

GRANT statement
540
GRANT statement
Use this statement to create new user IDs, to grant or deny permissions to
specific users, and to create or change passwords.
GRANT CONNECT TO userid , …
[ AT
starting-id }
IDENTIFIED BY password , …
GRANT {
DBA,
GROUP,
MEMBERSHIP IN GROUP
userid , …,
[ RESOURCE | ALL ]
}
… TO
userid , …
GRANT {
ALL [ PRIVILEGES ],
ALTER,
DELETE,
INSERT,
REFERENCES [ (
column-name , … ) ],
SELECT [ ( column-name , … ) ],
UPDATE [ (
column-name , … ) ],
}
… ON [
owner .] table-name
… TO userid , …
[ WITH GRANT OPTION ]
GRANT EXECUTE ON [
owner .] procedure-name TO userid , …
GRANT INTEGRATED LOGIN TO
user_profile_name , … AS USER userid
Syntax 1 or 2 One of the following conditions must be met.
♦ You are changing your own password using GRANT CONNECT
♦ You have DBA authority
If you are changing another user’s password (with DBA authority), the other
user must not be connected to the database.
Syntax 3 One of the following conditions must be met:
♦ You own the table
♦ You have been granted permissions on the table with GRANT OPTION
♦ You have DBA authority
Syntax 4 One of the following conditions must be met:
Function
Syntax 1
Syntax 2
Syntax 3
Syntax 4
Syntax 5
Permissions