In SQL Query Analyzer, I execute:
grant execute on getDate to rolegroup
(getDate is a user defined stored procedure, rolegroup is a user defined role)
This is ok.
What would be the syntax like if I want to grant a permission to a user/role whom resides in another database.
Is there something like
grant execute on getDate to anotherdatabase@rolegroup
This is crucial for example if an object resides in master database and I need to grant the object to another database user/role.