My problem is as follows:
1- suppose you are in database db1
2- in db1 there is a role :role1
3- there is another database :db2
4- db2 contains a stored procedure :sp1
5- now, I want to grant the role (role1) in db1 a permission to
execute the stored procedure sp1 in db2
I hope anyone can help me in this point ...
karam_IT 0 Newbie Poster
Be a part of the DaniWeb community
We're a friendly, industry-focused community of developers, IT pros, digital marketers, and technology enthusiasts meeting, networking, learning, and sharing knowledge.