SEO
vBulletin Search Engine Optimization
| |||||||
| Register | FAQ | Members List | Calendar | Search | Today's Posts | Mark Forums Read |
04-08-2008, 03:24 PM
| ||||
| ||||
 sybase tempdb looses permissions after reboot 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      |
|
04-08-2008, 03:24 PM
| |||
| |||
| Re: sybase tempdb looses permissions after reboot Maria wrote: > 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? 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? |
|
04-08-2008, 03:24 PM
| |||
| |||
| Re: sybase tempdb looses permissions after reboot evoradba@yahoo.ca (Maria) wrote in message news:<351fd9d6.0404131247.7ae1ba42@posting.google. com>... > 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 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 |
|
04-08-2008, 03:26 PM
| ||||
| ||||
| Re: sybase tempdb looses permissions after reboot 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@sybase.com (Bret Halford) wrote in message news:<34c88f2b.0404131839.3cf42d2f@posting.google. com>... > evoradba@yahoo.ca (Maria) wrote in message news:<351fd9d6.0404131247.7ae1ba42@posting.google. com>... > > 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 > > 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 |
Linear Mode
