Skip to Main Content

Breadcrumb

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

Hello,
I wanted to ask about new 23C feature - Schema-level Privileges: is it possible to combine it with "WITH GRANT OPTION"?
According to documentation
https://docs.oracle.com/en/database/oracle/oracle-database/23/dbseg/configuring-privilege-and-role-authorization.html#GUID-EEE53C39-D610-4792-82EA-6F49B880B036
"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

Connor and Chris don't just spend all day on AskTOM. You can also catch regular content via Connor's blog and Chris's blog. Or if video is more your thing, check out Connor's latest video and Chris's latest video from their Youtube channels. And of course, keep up to date with AskTOM via the official twitter account.

More to Explore

Design

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