Zombie processes in ASE

When you do not have the row in sysprocesses but you do have in
syslocks that is zombie  lock ( i.e. phantom lock )
You will need to either recycle ASE server or use  dbcc . If you are
using  ASE 12.5.4 or later version , you can try using 'dbcc
lock_release'

A phantom [lock] is when there is an entry in syslocks for
a spid,  but the spid does not exist in sysobjects (phantoms
have no body, just cast a shadow).  Phantom locks are usually
due to bugs in process cleanup in the ASE. 

Bookmark this post:

Displaying access information from sysprotects

list privileges for each user

select u.name,v.name
 from sysprotects p, master.dbo.spt_values v, sysusers u
 where p.uid=u.uid
 and p.action=v.number
 and p.protecttype=1
 and v.type = 'T'
 and u.name!= 'dbo'
 go

Bookmark this post: