Книга: Fedora™ Unleashed, 2008 edition

Deleting Database Users in PostgreSQL

Deleting Database Users in PostgreSQL

To delete a database user, you use the dropuser command, along with the user's name, and the user's access is removed from the default database, like this:

$ dropuser msmith
DROP USER

You can also log in to your database by using psql and then use the DROP USER commands. Here's an example:

$ psql demodb
Welcome to psql, the PostgreSQL interactive terminal.
Type: copyright for distribution terms
 h for help with SQL commands
 ? for help on internal slash commands
 g or terminate with semicolon to execute query
 q to quit
demodb=# DROP USER msmith ;
DROP USER
demodb=# q
$

Оглавление книги


Генерация: 0.940. Запросов К БД/Cache: 3 / 0
поделиться
Вверх Вниз