Re: ***** Interesting Resource Permission Problem *****

>From: Chris Collins <ccollins@ndcinc.com> >Date: Tue, 15 Jul 1997 19:52:48 -0400 >X-Informix-List-Id: <news.40462> > >I am working for a company that has an Informix SE 5.07 database. We >need to add tables to this database, however I do not have Resource >Permission to do this. The system is fairly old, and the people who >orginally created the database have left - with their passwords. > >How can I give myself the permissions that I need? We tried becoming >Super User and logging in, but that didn't work. Do "SELECT * FROM 'informix'.sysusers". The entry or entries with D in the privilege column are the DBA logins. Recreate one of those logins; using the recreated login, assign DBA privileges as required; and then as the current DBA, remove the old DBA privileges; and finally remove the recreated login. I usually create a user account specifically as the DBA for a major system. It's a bit like having an extra root account, but it is a well known name which prevents that problem from recurring. Yours, Jonathan Leffler (johnl@informix.com) #include <disclaimer.h> PS: I decline to respond to messages with anti-spam in the return path.