asfentracker.blogg.se - Sql tabs postgresql super user

#Sql tabs postgresql super user password

#Sql tabs postgresql super user password

PASSWORD – The new Password is the string that you want to set as the password for the user.If neither ENCRYPTED or UNENCRYPTED property is specified and neither this is done while user creation then the default password storing mechanism is decided based on password_encryption configuration variable. UNENCRYPTED – The password is not stored in encrypted format in pg_catalog.

ENCRYPTED – This property determines whether the password stored in the pg_catalog’s pg_shadow table is stored in the form of an MD5 encrypted format.

NOCREATEUSER – When this property is mentioned in the query in the above format the user won’t be able to create new users.

CREATEUSER – This property can be specified to allow the user to create new users.

NOCREATEDB – This can be mentioned if you want to restrict the user from creating any new database.

CREATEDB – This can be specified if you want to give the privilege to the user to create a new database.

If not mentioned then the system assigns the value that is equal to maximum user-id plus one to the current user id that is being created.

SYSID uid – It is the user id that is assigned to the user when the user is created to identify the user uniquely in the database server.

Some of the option properties are mentioned in the following section. Option – We can change multiple parameters and privileges associated with the user using this format.Name – It is the name of the user or role whose properties or password you want to change.Using the above create command the new user can be created and along with that other options can also be assigned. Hadoop, Data Science, Statistics & othersĬREATE USER name option ]