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

In reply to Chris Collins's email about ***** Interesting Resource Permissi, on 15 Jul 97 > Hello All, Hi Chris, > > 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. > > Any suggestions on doing this? > You should login as user informix and execute the following. dbaccess dbname -> query -> new grant resource to chris and run this query. You should then be able to login as chris and continue creating tables etc. User informix is analogous to the super user in context of Informix products. However, if informix user does not exist, then you will have to create user informix with group informix.Also note that, user informix should be the one and only member of group informix. This is for security reasons. > Please email me with any responses - ccollins@ndcinc.com > > Thanks, > Chris > > ______________________________________________________________ > > Chris Collins > Consultant (MCPS) > NDC Group, Inc. > (703) 838-9720 ext 262 > ______________________________________________________________ HTH, Ravi.... -- Ravi Joseph Pinto, mailto:ravi@in.dhl.com Consultant, Astra Infotech, voice :91-22-8503000 Mumbai, India extn. 1531 If Network is computer, how come Sun makes servers, not routers ? PS : Standard disclaimers apply.