# INHERIT object PRIVILEGES not part of generated scriipt **URL:** \ **Category:** Toad for Oracle & DevOps Toolkit\ **Created:** [September 25, 2015, 6:58am UTC](https://forums.toadworld.com/t/inherit-object-privileges-not-part-of-generated-scriipt/34167 "2015-09-25T06:58:07Z")\ **Posts on this page:** 5\ **Page:** 1
**Author:** ![rkoroly](https://avatars.discourse-cdn.com/v4/letter/r/54ee81/32.png) [@rkoroly](https://forums.toadworld.com/u/rkoroly)\ **Post date:** [September 25, 2015, 6:58am UTC](https://forums.toadworld.com/t/inherit-object-privileges-not-part-of-generated-scriipt/34167/1 "2015-09-25T06:58:07Z")
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 ---
**Author:** ![JohnDorlon](https://sea1.discourse-cdn.com/quest/user_avatar/forums.toadworld.com/johndorlon/32/9997_2.png) [@JohnDorlon](https://forums.toadworld.com/u/JohnDorlon)\ **Post date:** [September 25, 2015, 7:16am UTC](https://forums.toadworld.com/t/inherit-object-privileges-not-part-of-generated-scriipt/34167/2 "2015-09-25T07:16:49Z")
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. ---
**Author:** ![rkoroly](https://avatars.discourse-cdn.com/v4/letter/r/54ee81/32.png) [@rkoroly](https://forums.toadworld.com/u/rkoroly)\ **Post date:** [September 25, 2015, 8:34am UTC](https://forums.toadworld.com/t/inherit-object-privileges-not-part-of-generated-scriipt/34167/3 "2015-09-25T08:34:04Z")
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](mailto:bounce-jdorlon@toadworld.com)] **Sent:** Friday, September 25, 2015 09:18 AM **To:** [toadoracle@toadworld.com](mailto: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](http://www.toadworld.com/products/toad-for-oracle/f/10/p/25491/56324#56324)** 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](http://www.toadworld.com/products/toad-for-oracle/f/10/t/25491?subscribe=false) on this subject. Or [ Unsubscribe from Toad for Oracle - General](http://www.toadworld.com/products/toad-for-oracle/f/10?subscribe=false) notifications altogether. Toad for Oracle - Discussion Forum [Flag](http://www.toadworld.com/products/toad-for-oracle/f/10/p/25491/56324?AbuseContentId=739d671b-65de-4e12-96c2-c3be0eca4004&AbuseContentTypeId=f586769b-0822-468a-b7f3-a94d480ed9b0&AbuseFlag=true) this post as spam/abuse. ---
**Author:** ![JohnDorlon](https://sea1.discourse-cdn.com/quest/user_avatar/forums.toadworld.com/johndorlon/32/9997_2.png) [@JohnDorlon](https://forums.toadworld.com/u/JohnDorlon)\ **Post date:** [September 25, 2015, 8:41am UTC](https://forums.toadworld.com/t/inherit-object-privileges-not-part-of-generated-scriipt/34167/4 "2015-09-25T08:41:28Z")
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. ---
**Author:** ![JohnDorlon](https://sea1.discourse-cdn.com/quest/user_avatar/forums.toadworld.com/johndorlon/32/9997_2.png) [@JohnDorlon](https://forums.toadworld.com/u/JohnDorlon)\ **Post date:** [September 25, 2015, 9:03am UTC](https://forums.toadworld.com/t/inherit-object-privileges-not-part-of-generated-scriipt/34167/5 "2015-09-25T09:03:35Z")
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.