Specifies the active/current primary role for the session. The currently active primary role sets the context that determines whether the current user has the necessary privileges to execute CREATE <object> statements or perform any other SQL action.
Authorization to perform any SQL action other than creating objects can be provided by secondary roles.
For more information, see Overview of Access Control.
USE SECONDARY ROLES , CREATE ROLE , ALTER ROLE , DROP ROLE , SHOW ROLES
name
Specifies the identifier for the role to use for the session. If the identifier contains spaces or special characters, the entire string must be enclosed in double quotes. Identifiers enclosed in double quotes are also case-sensitive.
To use a role, the role must have been granted to the user.
Only a single primary role can be active at a time in a user session.
Secondary roles enable you to perform SQL actions using the combined privileges of the other roles granted to you.
RetroSearch is an open source project built by @garambo | Open a GitHub Issue
Search and Browse the WWW like it's 1997 | Search results from DuckDuckGo
HTML:
3.2
| Encoding:
UTF-8
| Version:
0.7.4