use sybsystemprocs
go

sp_server
go
sp_usesright
go
sp_grantsagg
go
set ansi_permissions on
go
grant select  on usptvalues                   to public
go
grant execute on sp_add                       to public
go
grant execute on sp_addlogtha                 to public
go
grant execute on sp_addcomment                to public
go
grant execute on sp_alllocks                  to public
go
grant execute on sp_arguments                 to public
go
grant execute on sp_blockers                  to public
go
grant execute on sp_backexec                  to public
go
grant execute on sp_backexecall               to public
go
grant execute on sp_busy                      to public
go
grant execute on sp_cache                     to public
go
grant execute on sp_checkindexes              to public
go
grant execute on sp_checks                    to public
go
grant execute on sp_checksystables            to public
go
grant execute on sp_columnagg                 to public
go
grant execute on sp_columnsx                  to public
go
grant execute on sp_columnsunique             to public
go
grant execute on sp_common                    to public
go
grant execute on sp_currplan                  to public
go
grant execute on sp_datatype                  to public
go
grant execute on sp_date                      to public
go
grant execute on sp_db                        to public
go
grant execute on sp_dbdiff                    to public
go
grant execute on sp_dbopt                     to public
go
grant execute on sp_defaultcols               to public
go
grant execute on sp_defaults                  to public
go
grant execute on sp_depend                    to public
go
grant execute on sp_dependx                   to public
go
grant execute on sp_device                    to public
go
grant execute on sp_deviceright               to public
go
grant execute on sp_devicespace               to public
go
grant execute on sp_domainsright              to public
go
grant execute on sp_dropprocedure             to public
go
grant execute on sp_dumplog                   to public
go
grant execute on sp_enabletriggers            to public
go
grant execute on sp_execsizes                 to public
go
grant execute on sp_existsprocedure           to public
go
grant execute on sp_findtext                  to public
go
grant execute on sp_formatdate                to public
go
grant execute on sp_fragments                 to public
go
grant execute on sp_freedevice                to public
go
grant execute on sp_freespace                 to public
go
grant execute on sp_grant                     to public
go
grant execute on sp_grants                    to public
go
grant execute on sp_grantsagg                 to public
go
grant execute on sp_grantsall                 to public
go
grant execute on sp_grantscreate              to public
go
grant execute on sp_grantsme                  to public
go
grant execute on sp_grantsuser                to public
go
grant execute on sp_groups                    to public
go
grant execute on sp_groupsright               to public
go
grant execute on sp_identity                  to public
go
grant execute on sp_indexagg                  to public
go
grant execute on sp_indexes                   to public
go
grant execute on sp_indexes2                  to public
go
grant execute on sp_lastxact                  to public
go
grant execute on sp_length                    to public
go
grant execute on sp_lockagg                   to public
go
grant execute on sp_lockconfig                to public
go
grant execute on sp_locking                   to public
go
grant execute on sp_loggedmsgs                to public
go
grant execute on sp_logins                    to public
go
grant execute on sp_loginwhere                to public
go
grant execute on sp_me                        to public
go
grant execute on sp_members                   to public
go
grant execute on sp_new                       to public
go
grant execute on sp_newstats                  to public
go
grant execute on sp_nullcolumns               to public
go
grant execute on sp_objectagg                 to public
go
grant execute on sp_objectsunique             to public
go
grant execute on sp_oldxacts                  to public
go
grant execute on sp_ownedby                   to public
go
grant execute on sp_procs                     to public
go
grant execute on sp_refkeys                   to public
go
grant execute on sp_refkeysright              to public
go
grant execute on sp_refkeysx                  to public
go
grant execute on sp_remotelogins              to public
go
grant execute on sp_remoteservers             to public
go
grant execute on sp_removelogin               to public
go
grant execute on sp_roles                     to public
go
grant execute on sp_rolesright                to public
go
grant execute on sp_roletree                  to public
go
grant execute on sp_roletrees                 to public
go
grant execute on sp_rules                     to public
go
grant execute on sp_ruleuse                   to public
go
grant execute on sp_segmentdetail             to public
go
grant execute on sp_segments                  to public
go
grant execute on sp_selectivity               to public
go
grant execute on sp_server                    to public
go
grant execute on sp_set                       to public
go
grant execute on sp_showtable                 to public
go
grant execute on sp_showtables                to public
go
grant execute on sp_size                      to public
go
grant execute on sp_sizes                     to public
go
grant execute on sp_spacebyuser               to public
go
grant execute on sp_status                    to public
go
grant execute on sp_strategies                to public
go
--grant execute on sp_sybprocs                  to public
--go
grant execute on sp_sysroles                  to public
go
grant execute on sp_tableagg                  to public
go
grant execute on sp_tablesx                   to public
go
grant execute on sp_textreconstrain           to public
go
grant execute on sp_textreindex               to public
go
grant execute on sp_thalist                   to public
go
grant execute on sp_thaprint                  to public
go
grant execute on sp_thatruncate               to public
go
grant execute on sp_tree                      to public
go
grant execute on sp_trees                     to public
go
grant execute on sp_triggers                  to public
go
grant execute on sp_typeagg                   to public
go
grant execute on sp_units                     to public
go
grant execute on sp_unused                    to public
go
grant execute on sp_updatestatistics          to public
go
grant execute on sp_userroles                 to public
go
grant execute on sp_users                     to public
go
grant execute on sp_usertypes                 to public
go
grant execute on sp_uses                      to public
go
grant execute on sp_usesright                 to public
go
grant execute on sp_utilprocs                 to public
go
grant execute on sp_views                     to public
go
grant execute on sp_xactagg                   to public
go
sp_grantsagg
go

dump transaction sybsystemprocs with truncate_only
go
