B-трек (работаем в схеме lab_admindb):
GRANT USAGE ON SCHEMA lab_admindb TO app_reader, app_writer; GRANT SELECT ON ALL TABLES IN SCHEMA lab_admindb TO app_reader, app_writer; GRANT INSERT, UPDATE, DELETE ON TABLE orders, order_items TO app_writer; ALTER DEFAULT PRIVILEGES IN SCHEMA lab_admindb GRANT SELECT ON TABLES TO app_reader, app_writer;
B-трек (работаем в схеме lab_admindb):
GRANT USAGE ON SCHEMA lab_admindb TO app_reader, app_writer; GRANT SELECT ON ALL TABLES IN SCHEMA lab_admindb TO app_reader, app_writer; GRANT INSERT, UPDATE, DELETE ON TABLE orders, order_items TO app_writer; ALTER DEFAULT PRIVILEGES IN SCHEMA lab_admindb GRANT SELECT ON TABLES TO app_reader, app_writer;
// Пример кода
function hello(name) {
console.log(`Hi, ${name}!`);
}
hello("Sergey");