Skip to Main Content

Database Software

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

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

Dude!

I installed the Virtualbox guest additions in beta 8 recently, but there wasn't any need for kernel-headers or kernel-dev, etc. If I remember correctly, I simply choose Insert Guest Additions from the VM Devices menu and entered the root password. After the next restart I was able set screen resolutions. Did you try without installing kernel-headers?

3025127

Just downloaded the CD today https://www.oracle.com/technetwork/server-storage/linux/downloads/linux-beta-4409163.html . Workstation 8 has kernel-headers installed by default. Might be kernel-devel might be not required. I just added it just in case. Surely it's failing that missing package elfutils-libelf-devel. I was able to proceed only after installing elfutils-libelf-devel manually.

1 - 2

Post Details

Added on Jun 18 2020
4 comments
265 views