![]() REVOKE statement is used to withdraw the access priviliges given to a user by GRANT statement. GRANT ALL PRIVILEGES ON DATABASE database_name TO username Grant permission to create database ALTER USER username CREATEDB Grant superuser access to a user ALTER USER myuser WITH SUPERUSER 2. GRANT ALL PRIVILEGES ON ALL SEQUENCES IN SCHEMA schema_name TO username GRANT Connect to Database GRANT CONNECT ON DATABASE database_name TO username GRANT Usage on Schema GRANT USAGE ON SCHEMA database_name TO username Grant access to all tables in the database GRANT ALL PRIVILEGES ON ALL TABLES IN SCHEMA schema_name TO username You can also specify combination of these privileges in a statement. If you prefer, you can use the pgAdmin graphical user interface. ![]() Note: Privileges can be SELECT, INSERT, UPDATE, DELETE, TRUNCATE, REFERENCES, TRIGGER, CREATE, ALL. The procedure describes setting up the database server using the psql command-line tool. ALTER EXTENSION change the definition of an extension. ALTER EVENT TRIGGER change the definition of an event trigger. Syntax GRANT privileges ON object TO user ALTER DOMAIN change the definition of a domain. GRANT statement is used to provide access privileges to users to access the database. ![]() In this sub section, let us learn the usage of below commands in detail. Install and PostgreSQL There are two ways you can install PostgreSQL database: Install from yum Repository Install from Source Code To install it from yum, use the following command: yum install postgresql-server To install it from source code, follow these steps: 9 Steps to Install and Configure PostgreSQL from Source on Linux 2. ![]()
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |