May 2, 2005 at 3:55 am
Hi Gurus,
I have been assigned the role to update some scripts so that they can be used in SQL 2005. I have installed the CTP feature of Yukon.
I have a script in SQL 2000 which uses
grant all on mbt_view_vw_2 to mbt_normal_role_3
Any oif these grant all throws a message :
"The ALL permission is deprecated and maintained only for compatibility. It DOES NOT imply ALL permissions defined on the entity."
I have plenty of grant all in my scripts. So sql throws that many messages. These being warning messages, is there any way of supressing it. I dont want these messages to appear in my resultset.
Any ideas ...
--Kishore
May 5, 2005 at 8:00 am
This was removed by the editor as SPAM
May 5, 2005 at 10:21 am
Kishore,
The granularity of permissions and number in Yukon has greatly increased. There are schema permissions, definition permissions, etc. The idea is that you probably do not want to grant all permissions to someone, or you'd make them a dbo or other role. Instead, I'd do a search and replace to add select/insert/update/delete in the scripts.
Viewing 3 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply