GRANT error in SQL 2005: GRANT SELECT ON sysprocesses TO PUBLIC

GRANT error in SQL 2005: GRANT SELECT ON sysprocesses TO PUBLIC

Post by QWxleCBDV » Sun, 30 Jan 2005 03:57:04


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
 
 
 

GRANT error in SQL 2005: GRANT SELECT ON sysprocesses TO PUBLIC

Post by JohnnyAppl » Sun, 30 Jan 2005 04:10:33

Try USE <DBNAME> before executing the grant.



database.

 
 
 

GRANT error in SQL 2005: GRANT SELECT ON sysprocesses TO PUBLIC

Post by WertmanThe » Thu, 10 Feb 2005 06:57:05

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

Chris






due to
database.
not