Getting Invalid Object Name "PMUSER" error

[unknown]

I have set-up a PowerDesigner repository in SQL server 2000
database. I have added users to the repository, created a
group given appropriate permission, and assigned those users
to the created group. However, all my users are getting the
following error while trying to connect to the repository:

[Microsoft][ODBC SQL Server Drive][SQL Server]Invalid object
name "PMUSER". SQLSTATE = s0002

I have checked the PMUSER table in the database. I do not
see anything usual.

I will appreciate if someone give me a clue?

Thanks!

Jamali

[unknown]

It looks like there is a problem with the connection, but I'm just
guessing here.
First, can the clients verify that the ODBC connection is valid. There
should be a "Test" button for the data source. Is it OK?
Next, if you added the users, then I assume that the ADMIN account
works. Can you connect with that user to verify the repository?
--
Mike Nicewarner [TeamSybase]
http://www.datamodel.org
mike[at]datamodel[dot]org (can you figure what to change?)
Sybase product enhancement requests:
http://www.isug.com/cgi-bin/ISUG2/submit_enhancement

Post by unknown
I have set-up a PowerDesigner repository in SQL server 2000
database. I have added users to the repository, created a
group given appropriate permission, and assigned those users
to the created group. However, all my users are getting the
[Microsoft][ODBC SQL Server Drive][SQL Server]Invalid object
name "PMUSER". SQLSTATE = s0002
I have checked the PMUSER table in the database. I do not
see anything usual.
I will appreciate if someone give me a clue?
Thanks!
Jamali

[Marc]

Hi,

It looks like you defined distinct db-connection logins to access the
repository.
Actually, all users should access to the repository with the same database
login, then they access the repository using the repository login which
might be different for all users.
You can also grant access on repository table to PUBLIC group (in order to
allow database connection on the repository to all users), but you still
have to define distinct repository users for each person.

Marc.

Post by unknown
I have set-up a PowerDesigner repository in SQL server 2000
database. I have added users to the repository, created a
group given appropriate permission, and assigned those users
to the created group. However, all my users are getting the
[Microsoft][ODBC SQL Server Drive][SQL Server]Invalid object
name "PMUSER". SQLSTATE = s0002
I have checked the PMUSER table in the database. I do not
see anything usual.
I will appreciate if someone give me a clue?
Thanks!
Jamali

[unknown]

Database connection is fine. ADMIN account works perfectly.
When I connect to the database using my account, I can
connect to the Repository using other user account. That
tells me that the users' accounts in the Repository have
been set right.

One think I can tell for sure is that, despite having read
and write permission to the database, for some reason users
account cannot see the PMUSER table or all the repository
tables. Because this invalid object name error show only the
very first time when the repository is created.

Any other clue? Thanks!

Jamali

Post by unknown
I have set-up a PowerDesigner repository in SQL server
2000 database. I have added users to the repository,
created a group given appropriate permission, and assigned
those users to the created group. However, all my users
are getting the following error while trying to connect to
[Microsoft][ODBC SQL Server Drive][SQL Server]Invalid
object name "PMUSER". SQLSTATE = s0002
I have checked the PMUSER table in the database. I do not
see anything usual.
I will appreciate if someone give me a clue?
Thanks!
Jamali

[unknown]

Problem has been solved. It has to do with tables' owner.
Those tables were needed to set as dbo for others to read.

Thanks for all your help.

Jamali

Post by unknown
I have set-up a PowerDesigner repository in SQL server
2000 database. I have added users to the repository,
created a group given appropriate permission, and assigned
those users to the created group. However, all my users
are getting the following error while trying to connect to
[Microsoft][ODBC SQL Server Drive][SQL Server]Invalid
object name "PMUSER". SQLSTATE = s0002
I have checked the PMUSER table in the database. I do not
see anything usual.
I will appreciate if someone give me a clue?
Thanks!
Jamali