cancel
Showing results for 
Search instead for 
Did you mean: 

Need a SP to block all the users Including S-users from adding BP Master Date

pvinod_kumar
Participant
0 Kudos

Hi experts

I need a SP which will block all the Users including S-User's from adding New BP Master Date

Regards

Vinod

MD1
Active Contributor
0 Kudos

try this

SQL

IF @object_type = N'2' AND ( @transaction_type = N'A' )
begin
IF Exists
(Select '*' from OCRD b
inner join ousr c on b."UserSign" = c."USERID"
where b.CardCode=@list_of_cols_val_tab_del and c."UserSign"<>0 )
BEGIN
SELECT @Error = 2
SELECT @error_message = 'You Are not Auth.'

END
END

Accepted Solutions (1)

Accepted Solutions (1)

kothandaraman_nagarajan
Active Contributor

Hi,

Try this,

IF @object_type = N'2' AND ( @transaction_type = N'A' )

begin

IF Exists (Select '*' from OCRD b inner join ousr c on b."UserSign" = c."USERID"

where b.CardCode=@list_of_cols_val_tab_del and c."Userid"<>0 )

BEGIN

SELECT

@Error = 2 SELECT

@error_message = 'You Are not Auth.'

END

END

Regards,

Nagarajan

pvinod_kumar
Participant
0 Kudos

Hi sir

Your support was very much helpfull,

if i required to give any 2 person authority then how should be the Condition

Regards

Vinod

Answers (1)

Answers (1)

kothandaraman_nagarajan
Active Contributor
0 Kudos

Hi,

Why do you need such control on creating BP master data?

You can control using standard authorization for non-super users.

Regards,

Nagarajan

pvinod_kumar
Participant
0 Kudos

Thanks for the Support sir

This is the req from Management Level of the Customer

I have already Blocked via as per you said, but the managment need to block S-users also

Regards

Vinod