I want to give user access to database.

Bruce Zelenka

current state: Open, before: Closed
connection opened
warning or info: Invalid object name 'ProCSharp.Books'.
Statistics
BuffersReceived, value: 1
BuffersSent, value: 1
BytesReceived, value: 178
BytesSent, value: 124
CursorOpens, value: 0
IduCount, value: 0
IduRows, value: 0
PreparedExecs, value: 0
Prepares, value: 0
SelectCount, value: 0
SelectRows, value: 0
ServerRoundtrips, value: 1
SumResultSets, value: 0
Transactions, value: 0
UnpreparedExecs, value: 1
ConnectionTime, value: 83
ExecutionTime, value: 5879
NetworkServerTime, value: 10

current state: Closed, before: Open
completed
"ConnectionString": "Data Source=(localdb)\\MSSQLLocalDB;Initial Catalog=Books;Integrated Security=SSPI;""ConnectionString": "Data Source=(localdb)\\MSSQLLocalDB;Initial Catalog=Books;Integrated Security=SSPI;"

I think invalid object name 'ProCSharp.Books' means my user .'bruce' does not have authority to access database. How do i give user authority to access database? Thank you.

2 Replies

Know the answer? Post it — somebody with the same question will find it here.

Suraj Kumar7y ago
You are not right here, Invalid object means the table/view/procedure of that name not exist in that database. So, you need to create first before you can use it.

Hope, you understood it.
Jaish Mathews7y ago
For access issues, lot of Ref. if you serach with "sql server give user authority to access database?" like this. https://chartio.com/help/data-sources/granting-table-level-permissions-in-sql-server/

If user already there, you can skip user creation part, but make sure that user there in SQLServer too.