Книги автора: Fedora™ Unleashed, 2008 edition
/ Книги автора: Fedora™ Unleashed, 2008 edition
/ honorato bonafe
Книга: 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
$
Похожие страницы
- users
- Creating Users
- Deleting Users
- Configuring PostgreSQL
- Creating a Database in PostgreSQL
- Creating Database Users in PostgreSQL
- Granting and Revoking Privileges in PostgreSQL
- 5.3.4. Mobile Users
- Creating child domains within zones
- Deleting a Photo
- Информация заголовочной страницы (Database header)
- Database dialect