Create role statement
A CREATE ROLE statement is a database command that creates a named authorization role and may assign attributes or privileges.
Just Use Postgres!
The CREATE ROLE statement is a PostgreSQL SQL command that creates a database role and can assign role attributes.
- How it is used
- Creates an application-facing database identity for controlled connectivity and delegated business-data operations.
- How deep it goes
- Explains role creation, LOGIN, connectivity grants, and delegated data permissions, but stops short of broader role administration.
- Examples
- Uses coffee_chain_admin to query and update catalog data while rejecting table drops, table creation, and unrelated database connections.
- What you can do after
- Operate/configure a PostgreSQL role and verify its connection, data, and structural permissions with psql.
Read how Just Use Postgres! explains create role statement →
ScyllaDB in Action
A CREATE ROLE statement is a CQL command that creates a named authorization role.
- How it is used
- Creates named roles for application authorization after authentication is enabled on a ScyllaDB cluster.
- How deep it goes
- Defines basic creation, login options, inspection, and inheritance, while leaving permissions to GRANT statements.
- Examples
- Uses application and reviews_api roles, cqlsh commands, LIST ROLES, keyspace grants, and inherited permissions.
- What you can do after
- Operate/configure ScyllaDB authorization by creating roles, enabling login credentials, and delegating permissions through GRANT.
Read how ScyllaDB in Action explains create role statement →
Related concepts
- roleproduces · A role is a defined function, responsibility, perspective, or set of permissions associated with a participant in an organization or system.
These guides are generated from the text of Manning books by Manning's knowledge graph and link to the sections they draw on. The full books are available on liveBook and at manning.com.