Create New Database User

SQream enables you to add more privileged users to the system.

These commands work from any client.

Syntax

create_role_statement ::=

    CREATE ROLE role_name ;
    GRANT LOGIN to role_name ;
    GRANT PASSWORD 'new_password' to role_name ;
    GRANT CONNECT ON DATABASE db_name to role_name ;

role_name ::= identifier

Example

CREATE ROLE new_role_name ;
GRANT LOGIN TO new_role_name;
GRANT PASSOWRD 'my_password' TO new_role_name;
GRANT CONNECT ON DATABASE master TO new_role_name;
  • 51
  • 17-Feb-2017
  • 564 Views