Permission Oddity

[qsac]

Here is a wierd one.

When i login to QA on server one, i login as user Test1.

I than run a select * from TableName. The TableName is owned by Test1. This returns results.

Now, on server 2, the exact same set up. I get an invalid object name.

Does anyone have a clue?

Thanks,
Q

 

[SQLBill]

Are there any errors in the SQL Server Error Logs? How about the Windows Event Viewer Logs?

Are you sure it's the exact same set up?

In Enterprise Manager, drill down to the database, expand your database, right click on the table and see who owns it. Go to Security, click on Logins....is there a Test1 login? Does it have permissions on the database?

-SQLBill

Posting advice: FAQ481-4875

 

[qsac]

Test1 is the owner. And that user definately has dbo perms to that table.

This is so weird. Makes no sense.

No log errors, SQL or Windows!

Any other ideas?

 

[SQLBill]

When you use QA, when you connect the database text box will have your default database listed. Does it show the correct database?

Try this and let me know what resulted:

USE dbname --change dbname to the real database name
GO
SELECT * FROM TableName --change TableName to the real name

If that works, then you need to check which database is the default for Test1.

-SQLBill

Posting advice: FAQ481-4875