RLS Questions & Answers

1. Adding users

Adding users to access other applications to the PANTHEON database.

We can add a user with PANTHEON:

See the following instructions: Adding a user and Setting authorizations for a user.

For more complex settings, where we want to add a user to multiple databases.

Adding User and Charging Autorizations without Rights. We set permissions of the user with PANTHEON:

declare

@v_cUserId sysname = 'EU',

@v_nUserid Int;

begin

Exec ppa_user_create @v_cUserId, @v_cUserId, 0

Select @v_nUserid = U.anUserId from tPA_User U where U.acUserid = 'EU'

exec [dbo].[ppa_security_insert] @v_nUserid, False, False

end;

P

2. Droping users