Toad World® Forums

Grants

If I F4 describe a table or a view, the Script tab shows me any
“grant” statements associated with it. Why not the same with the
“Source” tab for functions? Is there a difference between
“Script” and “Source”, or did we have two people or
teams naming them?

And what determines the order of the tabs? “Source” comes first with
functions, “Script” comes second with views, and
“Script” comes sixth with tables.

Thanks much,

Dan

Daniel B Madvig
Computer Technologies

Northwestern College & Northwestern Media
3003 Snelling Ave.
St. Paul, MN 55113
www.nwc.edu

651.631.5323

image001.jpeg
image001.jpeg

Jim McDaniel originally named them both. I just continued with the convention
when he left and I took over the Schema Browser.

I think of a “script” as a series of one or more sql statements. In
most of the SB RHS tabs, the script tab contains:

The sql statements to drop the object (optional)

The sql statements to create the object

The sql statements to create related objects (indexes, grants, synonyms, etc)

I think of “source” as the stuff you find in dba_source for a given
object.

I’m not sure what would happen if we added grants and synonyms
(optionally, of course) to the end of the data on the ‘Source’ tab
for those. For package/proc/func describe windows, I’d have to add an
extra level in the navigator tree. That would probably be the only change
needed.

You can get the ‘script’ for proc/func/packages using the LHS
‘Script’ toolbar button.

The first tab on the RHS is what I thought would be most important to users
(there is also a little bit of ‘what loads fastest’ factored in
there too). You can right-click on those RHS tabs to rename or rearrange them.
image001.jpeg

Thanks, Mon. J

Dan
image001.jpeg