server roles

[juneloo]

Hello,

I wish to access the log files information by using a login account (db_owner). But it dosen't work because it needs to login as sysadmin role. If my user acount being included in the sysadmin role, does it mean i can alter other database even I'm not their db_owner?



Best Regards,
Juneloo

[MAK]

if you are a sysadmin then you are the messiah.

[juneloo]

Originally posted by MAK
if you are a sysadmin then you are the messiah.

Hello,

Thanks for the reply. Actually I'm not the Server owner. But I have a database in it and i have the db_owner authority. It's anyway I can shrink the log file's size (my own database) without access sys_admin role (Server admin will not assign me as a sys_admin role because of the security reason).

[MAK]

DBCC SHRINKDATABASE permissions default to members of the sysadmin fixed server role or the db_owner fixed database role, and are not transferable.

but you can do this


use mydatabase
go
checkpoint
go
sp_dboption 'x','trunc. log on chkpt.',true
go

[MAK]

or alter database and change the recovery mode to simple.



ALTER DATABASE permissions default to members of the sysadmin and dbcreator fixed server roles, and to members of the db_owner fixed database roles. These permissions are not transferable.