04-11-2014 10:09 PM
I have made an application in which I am communicating with database.
Let me explain about my application first.
1. Application starts and it asks for user name and password
2. After successful login data reading or writing from /to database.
All this information whether its data or user name or password, I am storing in same database but in different tables
Now If I login from limited user then I am able to login by entering user name and password but later I am not able to read/ write to database, but If I login from admin accout then everything runs smoothly.
This happened recently and I am sure this is permision issue..
04-11-2014 10:11 PM - edited 04-11-2014 10:18 PM
I am using datalink for accessing database. May be I need to change the permission in limited account
But if this is the case then why my login is working? It shouldn't work also
04-12-2014 07:49 AM
What database engine are you using? What Database driver and version? How is the security in the database server configured? Who maintains the database, yourself or an IT departement (who may have decided that the previous access configuration was way to insecure)?
04-14-2014 02:27 AM
SQL. There is no security. In other PC this works fine in limited users.
There is no IT.
What else can be casued?
04-14-2014 02:43 AM
SQL?? MySQL, MS SQL Server, Oracle SQL, PostgreSQL, SQLLite, .......
ADO driver you use?
versions of SQL server and ADO drivers?
There is obviously some security! If there wasn't any you would not get andy trouble to connect to your server with a normal user account.
04-14-2014 06:05 AM
MS SQL, Server V 7.0. I am sure this is not a security and version issue. Becasue in same PC it was working before and now it doesnt