granting permission to all tables in db SYBASE

database, permissions, sybase

Solution

Got the answer:

select 'grant all on ' + name + ' to <user_name>' from sysobjects where type = 'U' or type = 'P'
go

and use the query output to grant all necessary permission to all the tables and sps in db. If you have a better answer, please share.

Problem

Apologies for this question but I can't find proper answer on the web. I'm looking for query that grants all permissions to all objects in db(tables,sps, sys tables). I've tried multiple combination of grant all .... to user_name but can't find proper phrase. I'm working on SYBASE.

Original source