Jun 24th, 2013 at 09:26 PM

See the some examples to grant: Example 1: Give the users WINKEN, BLINKEN, and NOD the authority to connect to the database. GRANT CONNECT ON DATABASE TO USER WINKEN, USER BLINKEN, USER NOD Example 2: Grant BINDADD authority on the database to a group named D024. There is both a group and a user called D024 in the system. GRANT BINDADD ON DATABASE TO GROUP D024 Observe that, the GROUP keyword must be specified; otherwise, an error will occur since both a user and a group named D024 exist. Any member of the D024 group will be allowed to bind packages in the database, but the D024 user will not be allowed (unless this user is also a member of the group D024, had been granted BINDADD authority previously, or BINDADD authority had been granted to another group of which D024 was a member). Example 3: Give user Walid security administrator authority. GRANT SECADM ON DATABASE TO USER Walid