Tomas Lipensky - vedomostni koutek

Trace:

Differences

This shows you the differences between two versions of the page.

Link to this comparison view

Both sides previous revision Previous revision
db:postgresql [2026/06/22 06:04]
tomas 		db:postgresql [2026/06/22 10:43] (current)
tomas
Line 36: Line 36:
 GRANT ALL PRIVILEGES ON uzivatele TO tomas; ... prida vsechny prava na tabuklu uzivatele uzivateli tomas\\ GRANT ALL PRIVILEGES ON uzivatele TO tomas; ... prida vsechny prava na tabuklu uzivatele uzivateli tomas\\
 GRANT SELECT, UPDATE, INSERT ON uzivatele TO GROUP admins; ... prida SELECT, UPDATE, INSERT do tabulky uzivatele skupine admins\\ GRANT SELECT, UPDATE, INSERT ON uzivatele TO GROUP admins; ... prida SELECT, UPDATE, INSERT do tabulky uzivatele skupine admins\\
-CREATE ROLE role1 NOLOGIN ENCRYPTED PASSWORD '123mzdy'; +CREATE ROLE role1 NOLOGIN ENCRYPTED PASSWORD '123mzdy';\\ 
-GRANT SELECT, INSERT, UPDATE, DELETE ON uzivatele TO role1;+ALTER ROLE role1 WITH LOGIN; ... povolí uživateli role1 se připojovat\\ 
 +GRANT SELECT, INSERT, UPDATE, DELETE ON uzivatele TO role1;\\
 GRANT role1 TO petr; ... prida uzivatele petr ke clenum role role1\\ GRANT role1 TO petr; ... prida uzivatele petr ke clenum role role1\\
  
Line 43: Line 44:
 \d ... seznam vsech tabulek\\ \d ... seznam vsech tabulek\\
 \d uzivatele ... popis tabukly uzivatele\\ \d uzivatele ... popis tabukly uzivatele\\
-CREATE TABLE uzivatele (id bigserial NOT NULL, name char(50),  pwd char(32));... butvori tabulku uzivatele s hodnotami id, name, password\\+CREATE TABLE uzivatele (id bigserial NOT NULL, name char(50),  pwd char(32));... vytvoří tabulku uzivatele s hodnotami id, name, password\\ 
 +CREATE TABLE tabulka1 OWNER vlastnik1; ... vytvoří tabulku tabulka1, kterou vlastní vlastnik1\\
 ALTER TABLE uzivatele ADD COLUMN preznivka character varying(50) DEFAULT 'bez prezdivky'; ... prida sloupec do tabulky\\ ALTER TABLE uzivatele ADD COLUMN preznivka character varying(50) DEFAULT 'bez prezdivky'; ... prida sloupec do tabulky\\
 ALTER TABLE uzivatele ALTER COLUMN prezdivka SET NOT NULL; ... zmodifikyje sloupec\\ ALTER TABLE uzivatele ALTER COLUMN prezdivka SET NOT NULL; ... zmodifikyje sloupec\\
Last modified: 2026/06/22 10:43
GNU Free Documentation License 1.3 Except where otherwise noted, content on this wiki is licensed under the following license: GNU Free Documentation License 1.3