Forum Replies Created

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

  • RE: Database permission disapers

    Hi,

    with some SQLcode everything is fine again.

    /*

    use DPR_

    go

    create user [DEF] for Login [DEF]

    go

    use DPR_

    EXEC sp_addrolemember N'db_datareader', N'DEF'

    go

    use DPR_

    EXEC sp_addrolemember N'db_datawriter', N'DEF'

    go

    */

    I have no idea why gui would not make it...

  • RE: Database permission disapers

    Hi HanShi,

    Thank you for your relply!

    Unfortunatly I already ran the statement you quoted.

    'exec sp_change_users_login 'report' '

    The resultset was empty.

    cu

    Stefan

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