- Database users are completely separate from operating system users.
- Database users are global across a database cluster.
- Username must be unique and require authentication.
- Every connection made to a database is made using a user.
- enterprisedbis a predefined superuserin default data cluster.
- Pre-defined superusername can be specified during initialization of the database cluster.
- This pre-defined superuserhave all the privileges with GRANT OPTION.
create user thourg commad
The create user utility can also be used to create a user
Syntax:
create user[OPTION]... [ROLENAME]
The create user utility can also be used to create a user
Syntax:
create user[OPTION]... [ROLENAME]
- Use --help option to view the full list of options available.
also see below
No comments:
Post a Comment