About dbexport grant permission
Posted in 2013
Topics: Security, Permissions & Auditing, Migration, Import/Export & Data Conversion
Hi, When i give the connect permission to abc user that time abc user didn't select permission to all tables. All tables grant permissions on select, update, insert & delete queries are not exported in export folder. e.g. There are 5 table like A, B, C, D & E Database name is San. Export folder name is san.exp In san.exp folder there are all 5 table create table script but all 5 tables grant permission not available. There are only 3 table grant select, update,insert,delete & index permission available because of this reason i didn't have select the table data. It shows the No select permission. Please tell me, what is the reason of this problem? Give me some solution.
At the least the user running the export must have connect and SELECT on all the tables. Ideally it should be run with a DBA user Regards On Thu, Mar 14, 2013 at 12:17 PM, SANDIP SHINDE <sandipvshinde1983@gmail.com > wrote: > Hi, > When i give the connect permission to abc user that time abc user didn't > select permission to all tables. > > All tables grant permissions on select, update, insert & delete queries are > not exported in export folder. > e.g. > There are 5 table like A, B, C, D & E > Database name is San. > Export folder name is san.exp > In san.exp folder there are all 5 table create table script but all 5 > tables > grant permission not available. There are only 3 table grant select, > update,insert,delete & index permission available because of this reason i > didn't have select the table data. It shows the No select permission. > > Please tell me, what is the reason of this problem? > Give me some solution. > > > > ******************************************************************************* > Forum Note: Use "Reply" to post a response in the discussion forum. > > -- Fernando Nunes Portugal http://informix-technology.blogspot.com My email works... but I don't check it frequently... --089e0111bbe6beac1d04d7e1b047