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

Category: QuestionsCan A Role Be Used To Define Privileges To Access Database Objects Of Another Schema In Procedures And Functions?
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?

1 Answers
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.