Created
September 6, 2016 08:13
-
-
Save gfodor/c360683f25f55497c8c657255fd0e0f8 to your computer and use it in GitHub Desktop.
This file contains bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
| psql (9.6rc1) | |
| Type "help" for help. | |
| test=# create role guy; | |
| CREATE ROLE | |
| test=# revoke all privileges on schema public from guy; | |
| REVOKE | |
| test=# revoke all on all tables in schema public from guy; | |
| REVOKE | |
| test=# set role guy; | |
| SET | |
| test=> create table foo (x int); | |
| CREATE TABLE | |
| test=> drop table foo; | |
| DROP TABLE | |
| test=> \q |
Sign up for free
to join this conversation on GitHub.
Already have an account?
Sign in to comment