Can A Role Be Used To Define Privileges To Access Database Objects Of Another Schema In Procedures And Functions?

› Category: Questions › Can A Role Be Used To Define Privileges To Access Database Objects Of Another Schema In Procedures And Functions?
0 Vote Up Vote Down
Editor">Editor Staff asked 2 years ago

Can A Role Be Used To Define Privileges To Access Database Objects Of Another Schema In Procedures And Functions?

Question Tags:
1 Answers
0 Vote Up Vote Down
Editor">Editor Staff answered 2 years ago

Database objects of another schema cannot be accessed in a procedure or function through roles; however, explicit privileges have to be granted to the user for those database objects.

Articles: 40643

Related Posts