Provider=SQLOLEDB;Integrated Security=SSPI;Initial Catalog=test; Data Source=k36;
Hello I have created a exe in vb6.0 using the above connection string, Users can access the application only by windows authentication.
In SQL server 2000 i gave the access to a windows user with db_datareader role and when the user tired to access got this error "Invalid Data source"
I gave the same user db_owner and it works with out error
I do not want to create users with role db_owner in SQL server.
How to make them just db_datareader?
Thanks
Hello I have created a exe in vb6.0 using the above connection string, Users can access the application only by windows authentication.
In SQL server 2000 i gave the access to a windows user with db_datareader role and when the user tired to access got this error "Invalid Data source"
I gave the same user db_owner and it works with out error
I do not want to create users with role db_owner in SQL server.
How to make them just db_datareader?
Thanks