Skip to Main Content

Database Software

Howto limit CREATE / ALTER ANY (PROCEDURE/VIEW...) to allow only specified schemas?

Stanislav StudenýJun 18 2020 — edited Jun 23 2020

Hello.

It there a way to limit CREATE / ALTER ANY (PROCEDURE/VIEW...) granted to USER1 to allow only CREATE/ALTER in specified schemas?

E.g. Something which will solve something like this : GRANT CREATE ANY PROCEDURE TO USER1 "ON USER2,USER3..".

Best Regards,

Stanislav

Comments
Post Details
Added on Jun 18 2020
4 comments
88 views