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.

All Forums  SQL Server 2000 Forums  Transact-SQL (2000)  Grant ALL

Author  Topic  kish Starting Member 45 Posts Posted - 2005-02-24 : 09:39:09 Hi All, I am using SQL Server 2000 and using Grant All function to gives permissions to some users. Here is the script: if not exists (select * from master.dbo.syslogins where name = 'mbt_user') begin execute sp_addlogin 'mbt_user','abc' end execute sp_adduser mbt_user grant all to mbt_user go I have installed Yukon-Beta3 on my different machine. There the same script giving me message. "The ALL permission is deprecated and maintained only for compatibility. It DOES NOT imply ALL permissions defined on the entity. " This is actually a warning message coming for using 'Grant All'. What Can I replace this "grant all" with so that it does not give any meesage on Yukon and also works in SQL 7.0 and SQL 2000. Thanks. --Kishore