restrict_oracle_privileges.sh

Edit online

This script applies to NCIM databases created using Oracle as RDBMS. This script is typically run once all Oracle databases and schemas are created, to revoke database creation privileges from the NCIM database user. If the script was run before, then it must be run again after each database schema update, to prevent database access errors. Schema updates are typically made when installing fix packs, by using the update_db_schemas.pl script. Only those operations that are required for Network Manager during run time will remain granted.

Running the script

To run the script, use a command line similar to the following:

$NCHOME/precision/scripts/sql/oracle/restrict_oracle_privileges.sh user_name password [-pdb pluggable_database_name]

Command-line options

The following table describes the command-line options for the restrict_oracle_privileges.sh script.

Table 1. restrict_oracle_privileges.sh command-line options
Command-line option	Description
`user_name`	Mandatory; the name of the database user. This is usually the system user.
`password`	Mandatory; password of the database user.
`-pdb pluggable_database_name`	Required only when running the script with Oracle 12c with RAC. Specifies the Oracle 12c pluggable database name.