Post reply

check what permission has in user

  • March 2, 2012 at 7:38 am

    #257813

    Today i have give access abc database as data_reader, i have seen in user--> property--> usermappings --database name here it is not showing any thing.

    I have checked that user account is connecting to the server after that

    click the database it is giving errror

    The database AdminMig is not accessible. (ObjectExplorer)

    can you please guide me

    🙂

  • March 2, 2012 at 8:10 am

    #1454201

    You have first map the user to corresponding login inorder to get access on database. specify the databse role in to the user.

  • March 2, 2012 at 8:13 am

    #1454203

    what is the status of the database?

    select state_desc, user_access_desc, is_read_only from sys.databases where name = 'AdminMig'

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

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