This is very strange ... while back I have to re create master db and
since then every time the ASE is re started tempdb looses is
permissions...
I don't know why? this is sybase version 12.0 on solaris 5.8
does any one know how can I fix this problem permently? is there a way
???

any help would be appreciated

Thanks
Maria

Maria wrote:

Tempdb is the one database that is rebuilt every time ASE
is booted. I assume it's in a JFS file and not a raw
partition? As what user are you running ASE? What user
owns the tempdb file when ASE boots? What's the ownership
of the ASE files and that directory hierarchy?

evoradba (AT) yahoo (DOT) ca (Maria) wrote in message news:<351fd9d6.0404131247.7ae1ba42 (AT) posting (DOT) google.com>...
What permissions are lost? Permissions on the tempdb devices?
User permissions within tempdb?

It may have been that you had some user permissions set up within
the model database, so that tempdb had them every time it was created.
When you rebuild the master database, did you rebuild the entire
master device (and thus also model), or was it really just the master
database you rebuilt?

-bret

Hi Bret

I have to re create the master database into a new device then I
loaded from a dump that I had, and since then everytime that ASE gets
started I loose permissions into TEMPDB.

DO I need to re create MODEL again?
bret (AT) sybase (DOT) com (Bret Halford) wrote in message news:<34c88f2b.0404131839.3cf42d2f (AT) posting (DOT) google.com>...