Using below syntax we can grant usage privileges on Public schema to the user.
Syntax:
GRANT USAGE ON SCHEMA PUBLIC to <User Name>
Example:
GRANT USAGE ON SCHEMA PUBLIC to Test_User
See also:
- User creation
- Grant usage on schema public
- Create Schema
- Grant all privileges on a schema to the user
- Set default search path
No comments:
Post a Comment