MS SQL

SQL Permissions

Please support our MS SQL advertiser: Intel Parallel Studio Home

•

Join Date: Apr 2007

Posts: 1

Reputation: jwhelan is an unknown quantity at this point

Solved Threads: 0

jwhelan

Offline

Newbie Poster

SQL Permissions

Apr 19th, 2007

Hi all,

I am writing a web interface which uses a MSSQL Server 2000 database. I have checked and double checked all permissions and can't find any problems but when I run a

Help with Code Tags

MS SQL Syntax (Toggle Plain Text)

SELECT * FROM sales

I get the 'Permission denied for `sales` database `dbasename` database owner `sqluser`

I connect with the string

 Help with Code Tags 
 MS SQL Syntax (Toggle Plain Text) 
mssql_connect("server","sqluser","passwd");
mssql_connect("server","sqluser","passwd");

and this connects fine, so I am attempting to select all the components from a table that the user I connect with owns. As a sideline, I can create tables, but cannot read them in any way.

Any advice would be appreciated.
Thanks

•

Join Date: Oct 2005

Posts: 523

Reputation: pty is on a distinguished road

Solved Threads: 37

pty

Offline

Posting Pro

Re: SQL Permissions

Apr 19th, 2007

•

Originally Posted by jwhelan

Hi all,

I am writing a web interface which uses a MSSQL Server 2000 database. I have checked and double checked all permissions and can't find any problems but when I run a
Help with Code Tags

MS SQL Syntax (Toggle Plain Text)
SELECT * FROM sales
select * from sales
I get the 'Permission denied for `sales` database `dbasename` database owner `sqluser`

I connect with the string
Help with Code Tags

MS SQL Syntax (Toggle Plain Text)
mssql_connect("server","sqluser","passwd");
mssql_connect("server","sqluser","passwd");
and this connects fine, so I am attempting to select all the components from a table that the user I connect with owns. As a sideline, I can create tables, but cannot read them in any way.

Any advice would be appreciated.
Thanks