Currently I am at a site that is using PeopleSoft with informix. They have a username of sysadm75 that is also the owner of the PeopleSoft tables. It seems only the owner of the tables can select, update, insert delete, etc. Therefore everything has to be set up using the sysadm75 username and password. Is there not a way to give permissions to a username other than the owner of the table to to Query against that table>
Tek-Tips is the largest IT community on the Internet today!
Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!
-
Congratulations IamaSherpa on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
informix owner 1
- Thread starter Conley
- Start date
-
1
- #2
I'm not familiar with PeopleSoft. I am guessing that creating new permissions using the normal Informix commands isn't possible? But - in case I'm wrong, all you would need to do is issue the following command:
grant select, insert, delete, update on table to public; (where 'table' is the name of the table you are granting permission to)
You also need to be sure that 'public' has connect permission for the database:
grant connect to public;
You can also give public DBA permissions which will mean everyone will have the same access as the owner, in this case sysadm75:
grant dba to public;
Jane
grant select, insert, delete, update on table to public; (where 'table' is the name of the table you are granting permission to)
You also need to be sure that 'public' has connect permission for the database:
grant connect to public;
You can also give public DBA permissions which will mean everyone will have the same access as the owner, in this case sysadm75:
grant dba to public;
Jane
- Status
Similar threads
