var sidebar_align = 'right';
var content_container_margin = parseInt('290px');
var sidebar_width = parseInt('270px');
Unanswered: database schema permissions query
A second question, for all database schema, what is the basic query to retrieve all database objects that has any sort of permission on a given Sybase login id?
Carlson Wagonlit Travel Database Administrator
1. join sysobjects with sysprotects using id
Originally Posted by powerdude
2. filter for sysobjects.type
3. test sysprotects.action
== 193 = select perms
== 195 = insert perms
== 196 = delete perms
== 197 = update perms
== 224 = exec perms (procs)
There is probably a more complete list published somewhere, but these are the ones I can think of at the moment. The method is the same for all.
PART II --- to link to login
Originally Posted by stuarta
use master..syslogins to obtain dbname
check sysusers table in "dbname" for login id use (suid)
use the uid and suid cols to resolve these .. and filter the sysobjects with the sysusers.uid ..
you may have to check every database on the server, as dbname is the default db for the login .. the user may be aliased as well.. so a little thought will be required to address every contingency.