You can grant privileges directly to users with the GRANT statement, for example:
GRANT [privilege ... (, privilege)] ON [database_name|object_name] TO user_name ...[, user_name][WITH GRANT OPTION]
You must grant some privileges directly to users:
- For privileges that you cannot grant to a role, see Limitations on Using Roles.
- For a few users with truly unique needs, it may be more efficient to grant required privileges directly to the individual users.
Where possible, avoid granting privileges directly to users. Instead, grant privileges to roles and then grant role membership to users with similar database access needs. See Using Roles to Manage Privileges.