Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

 All Forums
 General SQL Server Forums
 New to SQL Server Programming
 #1044 SQL Error

Author  Topic 

jpcaps
Starting Member

2 Posts

Posted - 2010-10-21 : 11:53:29
Hi! Does anyone know what's causing this problem?

I wanted to delete a row in my sql table that has an empty string column. When I run this query:

Use Toybase;
Delete from vendors where vend_id = '';

I get the following error:
#1044 - Access denied for user 'toybase'@'%' to database 'TOYBASE'

Sachin.Nand

2937 Posts

Posted - 2010-10-21 : 11:59:17
The error itself is self explainatory.You dont have the necessary rights on the database "ToyBase"

PBUH

Go to Top of Page
   

- Advertisement -