Bryan Posted January 31, 2004 Posted January 31, 2004 Ok, I am running SQL 2000, and I have started a new project writing a ASP.NET page for a photo gallery This is the first time I have had to design a sql database on my own. I am able to connect to the database, but when I run the SQLDataAdapter.Fill command I get this error: Exception Details: System.Data.SqlClient.SqlException: SELECT permission denied on object 'PhotoList', database 'H_bdaniel5', owner 'dbo'. Can someone assist me in setting up the SQL permissions and security stuff, I don't know how to do it. Quote
bungpeng Posted February 3, 2004 Posted February 3, 2004 Open your SQL Enterprise Manager, in the security folder -> Logins -> [username] -> Properties... you can set it here Quote
akiaz Posted February 3, 2004 Posted February 3, 2004 I think you have to give the dbo user db_owner permission as the db_datareader and db_datawriter do not allow your query. I had to do this to get a new app running with a special user I added to the db for web application access. Quote
*Gurus* Derek Stone Posted February 3, 2004 *Gurus* Posted February 3, 2004 Run the following using OSQL.exe. GRANT SELECT ON Quote Posting Guidelines
bungpeng Posted February 4, 2004 Posted February 4, 2004 What is this mean? Is it only allow user to read record from this table or read/write on it? What is the advantage of using this command? Quote
*Gurus* Derek Stone Posted February 5, 2004 *Gurus* Posted February 5, 2004 The command above is the line of T-SQL sent to Microsoft SQL Server by Enterprise Manager or any other client to set the appropriate permissions. This is the command line version, while EM would be the GUI version. They do the same thing, but seeing how the command line is much faster it should be used instead. Quote Posting Guidelines
Recommended Posts
Join the conversation
You can post now and register later. If you have an account, sign in now to post with your account.