Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- -- Uprawnienia użytkownika
- CREATE PROCEDURE p3_select_user_permissions(@userId int)
- AS
- IF (select count(id) FROM p3_user_users WHERE id = @userId ) != 0
- BEGIN
- SELECT
- p3_user_permissions.system_name AS [Nazwa systemowa],
- p3_user_permissions.name_pl AS [Tłumaczenie polskie]
- FROM p3_user_permissions
- INNER JOIN p3_user_role_permissions ON p3_user_permissions.id = p3_user_role_permissions.permission_id
- -- Omijamy tabele roles, gdyż nie jest nam ona potrzebna [OPTYMALIZACJA ZAPYTANIA]
- INNER JOIN p3_user_user_roles ON p3_user_user_roles.role_id = p3_user_role_permissions.role_id
- -- Omijamy tabele users, gdyż nie jest nam ona potrzebna [OPTYMALIZACJA ZAPYTANIA]
- WHERE p3_user_user_roles.user_id = @userId
- ORDER BY p3_user_permissions.system_name
- END
- ELSE
- BEGIN
- SELECT 'User with this ID do not exists.'
- END
- GO
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement