Post reply

user permissions connect to database

  • March 18, 2010 at 10:59 am

    #221931

    Hi,

    I have a user named teste1, it's a SQL Server user.

    I gave him only public role. then , in one table of a database i gave this user the permissions to select data.

    Can a user with this permissions connect to the server?

    Thank you

  • March 18, 2010 at 11:17 am

    #1136175

    You would have to create a login for the user for them to connect to the server, then creating the user gives them permission to connect to the database.

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

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