how do i set the permission for read and write into a database? i'm creating a program to view what is in the database(which is a different database application altogether) and reading from it using SQL. Error message shows "No read permission". i looked into the security settings of the database application and add all permission settings that i could find, but it still yields no good result. I cant read from the table. can any1 help?

Is the database (or any part of it) password protected?

No it is not password protected. anyway i somehow got my way with it. thanks for your time.

Hmn, can I ask what you did to fix it (or, was it just a stroke of luck)?