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
In summary, sys.sql_expression_dependencies doesn’t return the referenced objects of stored procedure. This works for SQL Server and in the online documentation it is likely mentioned as supported scenario. Unfortunately, it is not supported at the moment. Please add this functionality.0 votes
- Don't see your idea?