I have created a Username and password for a user and created a database and granted all rights to this user for that DB. I used the username and password to connect the ODBC and test connection was successful.
in the database the database owner of this db is the user whom i have created. Now i tried connecting using asp but got an error "Invalid object name " "table name" .
I have an ASP file that was working just fine and now it does not. I get a script timeout error message. I have not made any changes so I suspect that my hosting service has done something to the rights on my MDB file. Both the MDB and my script work fine when hosted locally. In my FTP client, it shows that rights on the MDB as rwxrwSrwt. Is
this the correct setting for my ASP to access it? This is hosted on a Windows 2003 Server....
I am building a web application using ASP & Oracle 9i. Everything works well in terms of Add, Delete, Modify etc. Now I would like to add additional functionality to it. I am trying to user rights while website is running, which means, I should have a webpage, on which all the forms related to a particular module should be listed and I can define user rights like add, delete etc. Once the rights are defined for a particular user, the same rights should be distributed to all the respective pages as well. It's like creating VIEWS for different users.
How can this be done in ASP?
Is there any way to use asp to determine a users SQL Server database access rights.
I.e I have given a users data read only/ data write only in SQL server, how can I pick that up in an application so that only write only users can see a hyper link.
I know I could create a few more pages with a table in a database with various rights but I just want to read rights directly allocated from SQL Server.