5.3. Назначение прав доступа

Опишем права доступа к отношениям и представлениям для каждой группы пользователей.

• для администратора:

grant select, insert, update, delete on Songs to admin;

grant select, insert, update, delete on Musicans to admin;

grant select, insert, update, delete on Carriers to admin;

grant select, insert, update, delete on A-Singers to admin;

grant select, insert, update, delete on B_Song_Car to admin;

grant select, insert, update, delete on Quality to admin;

grant select, insert, update, delete on Size to admin;

grant select, insert, update, delete on Genres to admin;

grant select on Songs_Singers to admin;

grant select on Default to admin;

grant select on Author_Songs to admin;

grant select on Singer_Songs to admin;

grant select on Song_Singers to admin;

grant select on Songs_Carriers to admin;

grant select on Authors_Songs to admin;

grant select on Year_Songs to admin;

grant select on High_Quality to admin;

• для владельца музыкальных произведений:

grant select, insert, update, delete on Songs to owner_musics;

grant select, insert, update, delete on Musicans to owner_musics;

grant select, insert, update, delete on A-Singers to owner_musisc;

grant select, insert, update, delete on Quality to owner_musics;

grant select, insert, update, delete on Genres to owner_musics;

grant select on Songs_Singers to owner_musics;

grant select on Default to owner_music;

grant select on Author_Songs to owner_musics;

grant select on Singer_Songs to owner_musics;

grant select on Song_Singers to owner_musics;

grant select on Songs_Carriers to owner_music;

grant select on Authors_Songs to owner_musics;

grant select on Year_Songs to owner_music;

grant select on High_Quality to owner_musics;

• для слушателя:

grant select on Songs to listener;

grant select on Musicans to listener;

grant select on Carriers to listener;

grant select on A-Singers to listener;

grant select on B_Song_Car to listener;

grant select on Quality to listener;

grant select on Genres to listener;

grant select on Songs_Singers to listener;

grant select on Author_Songs to listener;

grant select on Singer_Songs to listener;

grant select on Song_Singers to listener;

grant select on Authors_Songs to listener;

grant select on Year_Songs to listener;

grant select on High_Quality to listener;

• для владельца носителей:

grant select on Songs to owner_carriers;

grant select on Musicans to owner_carriers;

grant select, insert, update, delete on Carriers to owner_carriers;

grant select on A-Singers to owner_carriers;

grant select, insert, update, delete on B_Song_Car to owner_carriers;

grant select, insert, update, delete on Size to owner_carriers;

grant select on Genres to owner_carriers;

grant select on Songs_Singers to owner_carriers;

grant select on Default to owner_carriers;

grant select on Author_Songs to owner_carriers;

grant select on Singer_Songs to owner_carriers;

grant select on Song_Singers to owner_carriers;

grant select on Songs_Carriers to owner_carriers;

grant select on High_Quality to owner_carriers;