OSEC

Neohapsis is currently accepting applications for employment. For more information, please visit our website www.neohapsis.com or email hr@neohapsis.com
 
Problem with create usergroup and create user !

A.Beermannpiepenbrock.de
Date: Mon Jun 14 2004 - 05:31:06 CDT


Hello !

From my application i connected as dba to an existing database via odbc
and fired the follwing commands

create usergroup PROGRAMMIERER RESOURCE
create usergroup ANWENDER STANDARD

create user PROGI PASSWORD XXX USERGROUP PROGRAMMIERER
create user STUSER PASSWORD XYZ USERGROUP ANWENDER

I did this with my local database (Windos XP) and with the server
database(Linux)
Everything ok ! No errors !

When i connect to the server database via sqlstudio everything looks
great !
I see the usergroups under owned users
I see the users under owned usergroups

When i connect to the local database via sqlstudio an error apears!
Module: Catalog View
Function: LoadOwnedUsers
ErrorNo: 35610
Error: Ungültiges Objekt
??????????

I can see the usergroups under owned users
I can't see any users under owned usergroups ???????

I tried to drop the usergroup objects via sqlstudio
Same error

What goes wrong ????
How to drop the created usergroups ????

Any help welcomed

Mit freundlichen Grüssen

Albert Beermann

                    '''''
                  '''''''''
                    (0 0)
 +---------oOO-------(_)-------------------+
 | Tel: 0541/5841-868 |
 | Fax: 0541/5841-869 |
 | Mail: mailto:a.beermannpiepenbrock.de |
 | Internet: http://www.piepenbrock.de |
 +-------------------------------oOO-------+
                   |__|__|
                    || ||
                   ooO Ooo