Post reply

Grant all

  • February 18, 2005 at 7:40 am

    #76241

    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. "

    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

     

     

  • February 21, 2005 at 8:00 am

    This was removed by the editor as SPAM

  • February 22, 2005 at 1:06 am

    #543411

    I did some research on Yukon.

    I could find a substitute in YUKON (grant CONTROL to mbt_user) which I guess works the same way as ALL in earlier versions of sql server (7, 2000).

    But 'CONTROL' DOES NOT work in earlier versions.

    So, if we are having common scripts for all versions then this will not work.

    We will have to find out something common which works on all versions of SQL Server. I mean 7.0 and above.

     

Viewing 3 posts - 1 through 2 (of 2 total)

You must be logged in to reply to this topic. Login to reply