Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
mvandoni
Starting Member
12 Posts |
 Posted - 2010-12-30 : 07:50:31
|
| I have a SQL Server 2008 and I often manage it using MSSMS express installed on my machine.Today I was on the real server and I had to change permission at column level for a table but I found the button Column Permission in table Properties-->Permissions not enabled and the Grant flag for Alter Permission is not checked.If I look at exactly the same page on my pc I see that Alter permission for the same user and for the same table is partially granted (green square insead of check) and the button Column Permission is enabled and allow me to access to a new page to grand specific permission on columns.These are the properties on my machine:Microsoft SQL Server Management Studio 10.0.1600.22 ((SQL_PreRelease).080709-1414 )Microsoft Data Access Components (MDAC) 2000.085.1132.00 (xpsp.080413-0852)Microsoft MSXML 2.6 3.0 4.0 5.0 6.0 Microsoft Internet Explorer 8.0.6001.18702Microsoft .NET Framework 2.0.50727.3603Sistema operativo 5.1.2600And these are those on the server:Microsoft SQL Server Management Studio 10.0.4000.0Microsoft Analysis Services Client Tools 10.0.4000.0Microsoft Data Access Components (MDAC) 3.86.3959Microsoft MSXML 2.6 3.0 5.0 6.0 Microsoft Internet Explorer 6.0.3790.3959Microsoft .NET Framework 2.0.50727.3615Operating System 5.2.3790Does anybody knows why of this difference?ThanksMichele |
|
|
webfred
Master Smack Fu Yak Hacker
8781 Posts |
Posted - 2010-12-30 : 09:22:32
|
If we click on the Select row, the button for Column Permissions activates.Look for that on this page: http://www.mssqltips.com/tip.asp?tip=2124
No, you're never too old to Yak'n'Roll if you're too young to die. |
 |
|
|
mvandoni
Starting Member
12 Posts |
Posted - 2010-12-30 : 09:43:37
|
| Ok forgive me for this stupid question...It was because of language.The first row in the permission list in the Italian GUI is Aggiornamento which stays for Update in English.Being the server installed in english on the first row I find Alter which obviously doesn't have column permissions...Clearly if I select Update everything works!Thanks for your answer. |
|
|
|
webfred
Master Smack Fu Yak Hacker
8781 Posts |
Posted - 2010-12-30 : 09:48:46
|
Fine that got it working  felice anno nuovo 
No, you're never too old to Yak'n'Roll if you're too young to die. |
|
|
|
|
|
|
MSSMS and Column Permissions