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
I would like a command that would allow us to replicate a table and wait for the replication to complete. The reason for this is that often in ETL workflows you want to make sure the table is replicated before moving on to load the next set of tables. Currently the only way to wait for this is to first trigger a replication with a SELECT TOP 1 * FROM Table and then sit and poll a system view to wait for its completion.1 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?