Skip to Main Content


Question and Answer

Chris Saxon

Thanks for the question, Michal.

Asked: September 05, 2023 - 9:09 am UTC

Last updated: September 29, 2023 - 9:59 am UTC

Version: 23C

Viewed 100+ times

You Asked

I wanted to ask about new 23C feature - Schema-level Privileges: is it possible to combine it with "WITH GRANT OPTION"?
According to documentation
"WITH ADMIN OPTION" is only extension.

In other terms - would it be possible for user who got schema privileges to create view on top of tables from another schema or will we have to stick to object level privileges WITH GRANT OPTION included?

Thanks in advance,
kind regards

and Chris said...

Yes, WITH ADMIN OPTION is the only valid extension for schema-level privileges.

If you want to give WITH GRANT OPTION you'll have to stick with object level privileges.

More to Explore


New to good database design? Check out Chris Saxon's full fundamentals class.