Ygthkb

How can guns be countered by melee combat without raw-ability or exceptional explanations?

Can someone explain European graduate programs in STEM fields?

Existence of a strange function

Is it possible to narrate a novel in a faux-historical style without alienating the reader?

Boss asked me to sign a resignation paper without a date on it along with my new contract

In a post apocalypse world, with no power and few survivors, would Satnav still work?

Missing a connection and don't have money to book next flight

Could a civilization in medieval fantasy world sustain itself by occupying important trade hubs and taxing trade?

Why write a book when there's a movie in my head?

Buying a "Used" Router

Why do single electrical receptacles exist?

Will the duration of traveling to Ceres using the same tech developed for going to Mars be proportional to the distance to go to Mars or not?

Taking an academic pseudonym?

What is an efficient way to digitize a family photo collection?

Calculating list of areas between the curves in an intersection region

Expression for "unconsciously using words (or accents) used by a person you often talk with or listen to"?

How do I add a strong "onion flavor" to the biryani (in restaurant style)?

Coworker is trying to get me to sign his petition to run for office. How to decline politely?

Manager has noticed coworker's excessive breaks. Should I warn him?

What really causes series inductance of capacitors?

Is the tritone (A4 / d5) still banned in Roman Catholic music?

Is there any way to play D&D without a DM?

When does a person lose diplomatic status?

Can you say "leftside right"?

Create Role or Create user

PostgreSQL - automatically create a database for users on first loginPostgreSQL: Why is the schema owner not the database ownerPostgreSQL: a Login Role to only access ViewsFind objects linked to a PostgreSQL rolePostgreSQL Role Inheritance behavior in AWS RDSReplace oldSchema with newSchema in functionsPostgreSQL - Grant privileges as superuserIn pgPool-II 3.7.5 configuration pgpool.conf, is recovery_user a role or a system user?'Privileges dependent' error when try to drop a role/user even if there are no database attached and no role attributesIdeal way to start 'Database Server' in PostgreSQL 11

0

PostgreSQL version : 11.2

OS platform : RHEL 7.6

I am new to PostgreSQL. I have a CRM application whose data I want to store in my 11.2 PostgreSQL Database.

The Database name will be : crm_db

The schema name will be : crm_app

I want all the schema objects in crm_app schema to be owned by a database user called crm_usr.

Can I just create a DB user using CREATE USER command like below or should I create a ROLE called crm_usr ? What is the recommended way to do this in 11.2 (the latest version at the time of posting this ie.23-Feb-2019)

CREATE user crm_usr identified by tiger235;



CREATE DATABASE crm_db OWNER crm_usr;

postgresql

share

asked 9 mins ago

JoeHumbleJoeHumble

1

New contributor

JoeHumble is a new contributor to this site. Take care in asking for clarification, commenting, and answering.
Check out our Code of Conduct.

add a comment | 

0

PostgreSQL version : 11.2

OS platform : RHEL 7.6

I am new to PostgreSQL. I have a CRM application whose data I want to store in my 11.2 PostgreSQL Database.

The Database name will be : crm_db

The schema name will be : crm_app

I want all the schema objects in crm_app schema to be owned by a database user called crm_usr.

Can I just create a DB user using CREATE USER command like below or should I create a ROLE called crm_usr ? What is the recommended way to do this in 11.2 (the latest version at the time of posting this ie.23-Feb-2019)

CREATE user crm_usr identified by tiger235;



CREATE DATABASE crm_db OWNER crm_usr;

postgresql

share

asked 9 mins ago

JoeHumbleJoeHumble

1

New contributor

JoeHumble is a new contributor to this site. Take care in asking for clarification, commenting, and answering.
Check out our Code of Conduct.

add a comment | 

PostgreSQL version : 11.2

OS platform : RHEL 7.6

I am new to PostgreSQL. I have a CRM application whose data I want to store in my 11.2 PostgreSQL Database.

The Database name will be : crm_db

The schema name will be : crm_app

I want all the schema objects in crm_app schema to be owned by a database user called crm_usr.

Can I just create a DB user using CREATE USER command like below or should I create a ROLE called crm_usr ? What is the recommended way to do this in 11.2 (the latest version at the time of posting this ie.23-Feb-2019)

CREATE user crm_usr identified by tiger235;



CREATE DATABASE crm_db OWNER crm_usr;

postgresql

share

asked 9 mins ago

JoeHumbleJoeHumble

1

New contributor

JoeHumble is a new contributor to this site. Take care in asking for clarification, commenting, and answering.
Check out our Code of Conduct.

PostgreSQL version : 11.2

OS platform : RHEL 7.6

CREATE user crm_usr identified by tiger235;



CREATE DATABASE crm_db OWNER crm_usr;

share

asked 9 mins ago

JoeHumbleJoeHumble

1

New contributor

JoeHumble is a new contributor to this site. Take care in asking for clarification, commenting, and answering.
Check out our Code of Conduct.

share

asked 9 mins ago

JoeHumbleJoeHumble

1

New contributor

JoeHumble is a new contributor to this site. Take care in asking for clarification, commenting, and answering.
Check out our Code of Conduct.

asked 9 mins ago

JoeHumbleJoeHumble

1

New contributor

JoeHumble is a new contributor to this site. Take care in asking for clarification, commenting, and answering.
Check out our Code of Conduct.

asked 9 mins ago

JoeHumbleJoeHumble

1