Bruce Zelenka

Bruce Zelenka

  • NA
  • 32
  • 6.8k

I want to give user access to database.

Jul 30 2019 11:49 AM
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.

Answers (2)