GRANT error in SQL 2005: GRANT SELECT ON sysprocesses TO P..

I dont know but I am very curious about where you got Beta 3 ?

Chris





Alex CT wrote:
 > The following GRANT statement used to work in SQL 7.0 and 2000, but
due to
 > security enhancements in SQL 2005, it does not work anymore.
 >
 > GRANT SELECT ON sysprocesses TO PUBLIC
 >
 > I receive the message:
 >
 > Msg 4610, Level 16, State 1, Line 2
 > You can only grant or revoke permissions on objects in the current
database.
 > I have just installed SQL 2005 Beta 3, connected as 'sa' and I have
not
 > modified any security at all in SQL 2005.
 >
 > Does anybody knows how can I make it work?
 > And what are the changes in SQL 2005 Security?
 >
 > If you can send info about it it would be great.
 >
 > Best regards