# Unable to script out user

**URL:** <https://forums.toadworld.com/t/unable-to-script-out-user/59577>\
**Category:** Toad for Oracle - Beta\
**Created:** [June 18, 2024, 11:48pm UTC](https://forums.toadworld.com/t/unable-to-script-out-user/59577 "2024-06-18T23:48:46Z")\
**Posts on this page:** 4\
**Page:** 1

<div class="post-metadata">

**Author:** ![DougK](https://avatars.discourse-cdn.com/v4/letter/d/e9c0ed/32.png) [@DougK](https://forums.toadworld.com/u/DougK)\
**Post date:** [June 18, 2024, 11:48pm UTC](https://forums.toadworld.com/t/unable-to-script-out-user/59577/1 "2024-06-18T23:48:46Z")

</div>

Toad Beta 24.2.61.3952  
Oracle RDBMS 19.22  
Logged in as SYS

When opening the "Script" tab on a user, Toad runs the following query against a view that does not exist. BTW, OJVM is not installed in this database.

select kind, grantee, type\_schema, type\_name, name, action, enabled, seq  
from sys.dba\_java\_policy  
where 1=1  
and grantee = :OneObjectName  
order by seq;  
-- ORA-00942: table or view does not exist

Scripting a user in 17.1 does not query this view.

As a sanity check...

select \* from all\_objects where object\_name = 'DBA\_JAVA\_POLICY'  
no rows selected.

---

<div class="post-metadata">

**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:** [June 19, 2024, 12:16pm UTC](https://forums.toadworld.com/t/unable-to-script-out-user/59577/2 "2024-06-19T12:16:43Z")

</div>

Oops, there was some change to error handling for that SQL in beta. I must have made a mistake there. I'll fix.

Uncheck here and we won't run that query.

Notes:

- This will also exclude object privileges granted to the user.

 ![image](https://global.discourse-cdn.com/quest/original/3X/8/c/8c91429d5ef4b0de951f6c09d30398f20b64742a.png)

---

<div class="post-metadata">

**Author:** ![DougK](https://avatars.discourse-cdn.com/v4/letter/d/e9c0ed/32.png) [@DougK](https://forums.toadworld.com/u/DougK)\
**Post date:** [June 20, 2024, 7:50am UTC](https://forums.toadworld.com/t/unable-to-script-out-user/59577/3 "2024-06-20T07:50:15Z")

</div>

John,

Thanks for the quick reply. We will continue to use 17.1 to extract user scripts until it has been fixed in the beta. We need the associated grants included in the script, so unselecting that option in the beta is not a viable workaround.

Regards,  
Doug

---

<div class="post-metadata">

**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:** [June 20, 2024, 12:18pm UTC](https://forums.toadworld.com/t/unable-to-script-out-user/59577/4 "2024-06-20T12:18:07Z")

</div>

Sorry about that. It'll be fixed next beta.
