To share your objects with other users, first connect to the desired database (see Section Connecting to the Database). Use the New Share menu item in the
Sharing menu or the~ 
~ toolbar button to open a window where you can make your objects accessible to other users.
Initially, all your SQL statements are provided for sharing. If you want to share another object, select the object type in the Object Type combo box.
Thereafter, either use the~ 
~ button to select the objects marked for sharing in the left-hand list or use the~ 
~ button to
select all objects of the selected object type. If you want to cancel a selection, select the objects not to be shared in the right-hand list and use the~ 
~
or~ 
~ button.
If you want to share additional objects of another object type, select the desired object type and proceed as described above. After selecting all the objects to be shared, determine whether you want other users to be able to read your object. Finally, select the users to which the selected objects are to be made accessible in the Share with User combo box. If you want the selected objects to be accessible to all database users, select PUBLIC as user.
Use the~ 
~ button to make the selected objects accessible to the user(s) selected.
You can do this repeatedly in succession. To terminate the object sharing, select the~ 
~ button.