sql server gui copy column value to new row

WHERE OBJECT_NAME(dp.major_id) = N'MultiplePermissionsTest' SELECT dp., dp.state_desc, USER_NAME(dp.grantee_principal_id)ĪS, USER_NAME(dp.grantor_principal_id) AS Try the following to see this in action: USE ĬREATE TABLE dbo.MultiplePermissionsTest (Col1 INT) Then again, it would make sense to have that empty row if it the 'Grantor' cell was a drop-down of principals that would allow for selecting one to be used in the AS clause of the GRANT statement, but it isn't, so having the empty row seems more confusing than practical. I guess the GUI does not check the connection to filter out the empty rows when there is a non-empty 'Grantor' row for the same principal as the connection. If you change the 'With Grant' option as 'dbo', for example, it will simply update the entry for 'Grantor' = 'dbo'. Of course, I am not sure why there is that extra entry when you are connected as principal that already has a granted permission for what would be the same grantor since you can only have one row per grantor. the 'grantee') were already granted that same permission from two grantors, then you would see three entries for that same permission on this screen.įor the 'duplicate' entries that you are seeing, the one with the empty 'Grantor' column could be used to assign that same permission from a different grantor than the one listed in the other entry for that same permission (in this case it is: dbo). There are multiple entries because you can be granted the same permission multiple times, from different 'grantors'.

Sql server gui copy column value to new row