MSSQL Insert Permissions

[Laer6]

I am having what I believe to be permissions problems with my database. My company has one database that has already been designed and works fine. I have tried to create a new database using the same user to login and work with it.

The problem is that the INSERT commands do not work. It doesn't give an error, so much as when this code is executed:

rows = cmd.ExecuteNonQuery();

There are no rows updated, even though it should be inserting.

UPDATE, SELECT, and DELETE commands work fine. Is it a permission problem? If so, what do I need to do to fix it? Or, do I have to create a new user for the second database? If that is the case, I would need help with that too, because I tried doing that but I couldn't get that to work either.

Any help would be greatly appreciated.

[nomad]

I am having what I believe to be permissions problems with my database. My company has one database that has already been designed and works fine. I have tried to create a new database using the same user to login and work with it.

The problem is that the INSERT commands do not work. It doesn't give an error, so much as when this code is executed:

rows = cmd.ExecuteNonQuery();

There are no rows updated, even though it should be inserting.

UPDATE, SELECT, and DELETE commands work fine. Is it a permission problem? If so, what do I need to do to fix it? Or, do I have to create a new user for the second database? If that is the case, I would need help with that too, because I tried doing that but I couldn't get that to work either.

Any help would be greatly appreciated.

You might be able to do it yourself esp if you do not have Grant privileges on the system...
try this
GRANT privileges (privileges is can be select, insert but you want ALL)
on databasename.tablename (you can do this too database.* which gives you acess to all the tables.)
TO username
IDENTIFIED by "password";

nomad

nomad