The Full Stack Web Development - Add User via psql

This video tutorial demonstrates how to log into PSQL via the command line, create a new database, and manage users. It covers creating a database named 'Acme', adding a user 'dev user', and granting them superuser privileges. The tutorial also explains how to connect to the database as the new user and manage access privileges.

What command is used to log into PSQL with a specific username?

• psql -d [database]

• psql -h [host]

• psql -p [port]

• psql -U [username]

Which command is used to create a new database in PSQL?

• CREATE DATABASE [database]

• DROP DATABASE [database]

• CREATE USER [username]

• ALTER DATABASE [database]

How can you verify the creation of a new user in PSQL?

• SELECT * FROM pg_user;

• SHOW USERS;

• LIST USERS;

• DISPLAY USERS;

What command is used to make a user a superuser in PSQL?

• UPDATE USER [username] TO SUPERUSER;

• SET USER [username] AS SUPERUSER;

• GRANT SUPERUSER TO [username];

• ALTER USER [username] WITH SUPERUSER;

Which command allows you to change a user's password in PSQL?

• UPDATE USER [username] SET PASSWORD '[new_password]';

• MODIFY USER [username] PASSWORD '[new_password]';

• ALTER USER [username] WITH PASSWORD '[new_password]';

• CHANGE PASSWORD FOR [username] TO '[new_password]';

What is the command to grant all privileges on a database to a user?

• PERMIT ALL RIGHTS TO [user] ON [database];

• ALLOW ALL ACCESS TO [user] FOR [database];

• GIVE ALL PRIVILEGES TO [user] ON [database];

• GRANT ALL ON DATABASE [database] TO [user];

If you want to connect to a specific database as a user, what must you ensure?

• The database name is provided after the username.

• The user has no password.

• The user is a superuser.

• The database is empty.