sysattributes help

Hi All,

I'm having a lot of questions about sysattributes and it
seems that there is no way were we can completely understand
this table.

I have found for example that we only have "UR" rows in this
table not when we create a role, but when we grant a role to
an existing role.

Also that LG maps the logins that are bind to a user created
tempdb.

But I still have a lot of doubts about other object_type,
like for example having
object_type=PS
and object_cinfo=login

Or when do we have an row inserted in sysattributes with
object_type=L or U or GR.

Is there anyone that can give a good explanation on this
table, or some better (an more complete) documentation that
the one we can find in sybase books online???

Many thanks,
Sergio Diogo

This is a commoner's answer...

sysattributes stores everthing that does not fit in other tables. Any that
could be anything...

PS+Login stores information like the # of days for passwd expiration per
login.


--
Cory Sane
[TeamSybase]
Certified Sybase Associate DBA for ASE 15.0
"Sergio Diogo" wrote in message news:48b652e6.3622.1681692777-at-sybase.com...
> Hi All,
>
> I'm having a lot of questions about sysattributes and it
> seems that there is no way were we can completely understand
> this table.
>
> I have found for example that we only have "UR" rows in this
> table not when we create a role, but when we grant a role to
> an existing role.
>
> Also that LG maps the logins that are bind to a user created
> tempdb.
>
> But I still have a lot of doubts about other object_type,
> like for example having
> object_type=PS
> and object_cinfo=login
>
> Or when do we have an row inserted in sysattributes with
> object_type=L or U or GR.
>
> Is there anyone that can give a good explanation on this
> table, or some better (an more complete) documentation that
> the one we can find in sybase books online???
>
> Many thanks,
> Sergio Diogo

Thanks for the answer, but there is no documentation that
fully let us understand all that is stored in here and
how!???

Regards,
Sergio

> This is a commoner's answer...
>
> sysattributes stores everthing that does not fit in other
> tables. Any that could be anything...
>
> PS+Login stores information like the # of days for passwd
> expiration per login.
>
>
> --
> Cory Sane
> [TeamSybase]
> Certified Sybase Associate DBA for ASE 15.0
> "Sergio Diogo" wrote in message
> > news:48b652e6.3622.1681692777-at-sybase.com... Hi All,
> >
> > I'm having a lot of questions about sysattributes and it
> > seems that there is no way were we can completely
> > understand this table.
> >
> > I have found for example that we only have "UR" rows in
> > this table not when we create a role, but when we grant
> > a role to an existing role.
> >
> > Also that LG maps the logins that are bind to a user
> > created tempdb.
> >
> > But I still have a lot of doubts about other object_type
> > , like for example having
> > object_type=PS
> > and object_cinfo=login
> >
> > Or when do we have an row inserted in sysattributes with
> > object_type=L or U or GR.
> >
> > Is there anyone that can give a good explanation on this
> > table, or some better (an more complete) documentation
> > that the one we can find in sybase books online???
> >
> > Many thanks,
> > Sergio Diogo
>

Sergio Diogo wrote:
> Thanks for the answer, but there is no documentation that
> fully let us understand all that is stored in here and
> how!???
>

No, there isn't. Not even internally, as far as I know.
And new stuff often gets added as new features are developed.
sysattributes is very much like that drawer in the kichen
labled "misc.", or that store down the street with the
"Thimgs For Sale" sign in the window. :-)

However, the majority of the values are used by system
stored procedures. So by searching syscomments for
test like "%%", you can often find out how
a particular value is used and what it means.