Thanks stanislav,

I have created a newuser testone and assign permissin with below command

GRANT resource to 'testone'

But i need to create a user that have only view/table/procedure/funcation select, insert, update and edit permissions only.

I amtrying ot create a role with below command. please correct me.

create role one_test
grant select, insert, update on all table to one_test;

but i receive and error in this query