INHERIT object PRIVILEGES not part of generated scriipt

Toad for Oracle & DevOps Toolkit
1

The following is reported in the OBJECT GRANTS. Why this critical item is not included in the gerenated script?

Privilege Admin Grantee Grantor Object Owner Object Type Object Name Column Name Grant Type

INHERIT PRIVILEGES NO DBSNMP SYS SYS USER SYS Privilege

2

If you are in the schema browser, go to the SCRIPT tab on the right hand side.

Click the first toolbar button to open the script options dialog.

Click the USERS tab.

Make sure “Grants to the user” is checked.

3

THANKS,

The settings were not an issue. I verified all settings. Of the following two lines extracted from catsnmp.sql, the second line is not reproduced on the SCRIPTS panel. The privilege is confirmed within OBJECT GRANTS panel but appears to be ignored by SCRIPTS process. My version TOAD is 12.7.1.11 this was just updated because my prior version duplicated this issue and I had hoped for its repair.

grant inherit any privileges to DBSNMP;

grant inherit privileges on user SYS to DBSNMP;

–Begin Toad generated SCRIPT

DROP
USER DBSNMP CASCADE;

CREATE
USER DBSNMP

IDENTIFIED
BY

DEFAULT
TABLESPACE
SYSAUX

TEMPORARY
TABLESPACE TEMP

PROFILE NOLIMIT

ACCOUNT
UNLOCK;

– 3 Roles for DBSNMP

GRANT
AQ_ADMINISTRATOR_ROLE TO DBSNMP;

GRANT CDB_DBA TO DBSNMP;

GRANT OEM_MONITOR TO DBSNMP;

ALTER
USER DBSNMP DEFAULT
ROLE
ALL;

– 5 System Privileges for DBSNMP

GRANT
CREATE
PROCEDURE
TO DBSNMP;

GRANT
CREATE
TABLE
TO DBSNMP;

GRANT
INHERIT
ANY
PRIVILEGES
TO DBSNMP;

GRANT
SELECT
ANY
DICTIONARY
TO DBSNMP;

GRANT
SELECT
ANY
TABLE
TO DBSNMP;

– 9 Object Privileges for DBSNMP

GRANT

SELECT
ON APPQOSSYS.WLM_CLASSIFIER_PLAN TO DBSNMP;

GRANT

SELECT
ON APPQOSSYS.WLM_METRICS_STREAM TO DBSNMP;

GRANT

SELECT
ON APPQOSSYS.WLM_MPA_STREAM TO DBSNMP;

GRANT

SELECT
ON APPQOSSYS.WLM_VIOLATION_STREAM TO DBSNMP;

GRANT

EXECUTE
ON
SYS.DBMS_MANAGEMENT_PACKS
TO DBSNMP;

GRANT

EXECUTE
ON
SYS.DBMS_RANDOM
TO DBSNMP;

GRANT

EXECUTE
ON
SYS.DBMS_SERVER_ALERT
TO DBSNMP;

GRANT

EXECUTE
ON SYS.SYS_PLSQL_56DF3975_835_1 TO DBSNMP WITH
GRANT
OPTION;

GRANT

SELECT
ON SYS.USER$ TO DBSNMP;

From: John Dorlon [mailto:bounce-jdorlon@toadworld.com]

Sent: Friday, September 25, 2015 09:18 AM

To: toadoracle@toadworld.com

Subject: RE: [Toad for Oracle - Discussion Forum] INHERIT object PRIVILEGES not part of generated scriipt

RE: INHERIT object PRIVILEGES not part of generated scriipt

Reply by John Dorlon

If you are in the schema browser, go to the SCRIPT tab on the right hand side.

Click the first toolbar button to open the script options dialog.

Click the USERS tab.

Make sure “Grants to the user” is checked.

To reply, please reply-all to this email.

Stop receiving emails on this subject.

Or
Unsubscribe from Toad for Oracle - General notifications altogether.

Toad for Oracle - Discussion Forum

Flag
this post as spam/abuse.

4

They both show up for me using Toad 12.7. What version of Oracle are you connecting to? I tested with Oracle 12.1.0.2.

5

Oh, are you in the Generate Schema Script window? I can reproduce the problem there. If you go to the Schema Browser to get the script, then it will be included there. I’ll fix this soon.