GRANT Permission To User

Hello!



I'm using SQL Server 2005.

I'd like to register an UNSAFE Assembly to AdventureWorks database.

For this AdventureWorks database should have the "TRUSTWORTHY" property set
to true, which I did with no problems.

Owner of AdventureWorks database is "Master", which is e member of
Sysadminfixed server role.

Login "Master" should be granted with "UNSAFE ASSEMBLY" permission.



I run the following script :

USE master;

GRANT UNSAFE ASSEMBLY TO Master;

This is executed successfully, I mean with resulting message "Command(s)
completed successfully."

But I think no such permission is granted to Master in fact. Because :

1. First - the assembly could not yet be registered.

2. I go to Security/Logins node on the Server tree displayed in Object
Explorer. Then from the context menu of "Master" login I choose Properties.
Then I choose "Securables", then button "Add", then the last "Server"
radion - button, then "OK" - and I receive a grid with permissions to users.
I see that on the row "UNSAFE ASSEMBLY" for the "Master" login I have no
checked boxes. Even if I check these boxes and exiting with "OK", reentering
in the same grid mekes me aware that boxes "UNSAFE ASSEMBLY" are not checked
again.


.