At the moment, in Azure warehouse, we cant store the execution status of a stored procedure in a variable.
DECLARE @Res INT.
EXEC @Res = dbo.usp_xyz
It errors out with the below error.
Msg 103010, Level 16, State 1, Line 1
Parse error at line: 37, column: 1: Incorrect syntax near 'EXECUTE'.
Is there any workarounds, please post.1 vote
I would like to make use of Active Directory Groups for Row-Level Security.
In order to do so I need a functionality to know to which group a login belongs to:
1) a user logs in using AD. The user belongs to a specific group.
2) I can use xp_logininfo to know which group that login belongs to
3) i can use the group within a mapping table for RowLevel Security
4) the user can see only the rows allowed to the group he belongs to1 vote
Some time, we need to give access on production environment for a certain time period, either its select, ddl or dml. Currently its a manual process to revoke the access or we have to develop a process and routines to revoke them. It will be good if we could provide an expiry date with the grant statement it self and DBMS engine should auto take care of expiry on that date.1 vote
- Don't see your idea?