Skip to Main Content
Forums

Oracle Database Discussions

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!

Interested in getting your voice heard by members of the Developer Marketing team at Oracle? Check out this post for AppDev or this post for AI focus group information.

How to install -only- dbms_network_acl_admin on 11.2

EnriqueCNov 3 2014 — edited Nov 4 2014

I have an application that requires to create an ACL but the package is not installed on many of the databases. I read the package comes with XDB, but I really would not like to have to install XDB. Is there a way to install the package by itself and stil lbe fully functional? I think I read somewhere the possibility exists, but I cannot find now the source of that comment.

Thanks!

Enrique.

Comments

unknown-951199

Identify a database that contains the desired package, then export only this package so  you can subsequently import where needed.

Richard Harrison .

Hi,

Well the source of this package would seem to be

dbmsnacl.sql and prvtnacl.plb

These create the package spec and body - whether they can be installed in isolation from XDB i've no idea - you can try i guess......

so as sys run

@?/rdbms/admin/dbmsnacl.sql

@?/rdbms/admin/prvtnacl.plb

I guess you can always just drop the package if it doesn't work....

Cheers,

Rich

Pravin Takpire

Try this

sql> connect / as sysdba

sql> @?/rdbms/admin/catnacl.sql

sql> @?/rdbms/admin/dbmsnacl.sql

sql> @?/rdbms/admin/prvtnacl.plb

regards

Pravin

1 - 3
Locked Post
New comments cannot be posted to this locked post.

Post Details

Locked on Dec 2 2014
Added on Nov 3 2014
#general-database-discussions
3 comments
1,462 views