Gurus,
I am trying to grant permission for a role to be able to change their
passwords. I know that the role has to have exec and update permission to
the sysxlogins table and the sp_password procedure. How ever the role is not
on the Master database and that is where the sysxlogins table and the
sp_password procedure are. How do I give a role on another database
permission to sysxlogins table and the sp_password procedure or copy that
role to the master database?

Shawn Smith
Database Administrator
Fort Worth Star-Telegram
817-390-7094
817-291-5240 cell
817-667-2757 pager
[Email Address Removed]MS Sql Server LazyDBA home page