Whats problem with this Query?

[saulofg]

Whats problem with this Query?

select 'grant exec on ' + 'sp_name' + ' to ' + su.name as granttext
from db..sysobjects so,
db..sysprotects sp,
db..sysusers su
where so.name = 'sp_name '
and sp.id = so.id
and su.uid = sp.uid
order by su.name

on Sybase 12, Delphi 7.

the TZQuery always give a error message:
Row data is not avaliable

[kaiserilich]

use this

Code: Select all

select 'grant exec on ' + 'sp_name' + ' to ' + su.name as granttext 
from sysobjects so, 
sysprotects sp, 
sysusers su 
where so.name = 'sp_name ' 
and sp.id = so.id 
and su.uid = sp.uid 
order by su.name