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 strongm on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
Changing USER in Report
- Thread starter adebayo01
- Start date
Krishna751204
Programmer
use the grant command to give permissions to all the users. If you are writting sql statements in your reports write SchemaName.ObjectName notations.
For example, if you are using emp table in scott user. meens emp table is created in scott user.
Step 1.
In your reports sql coding use the following sql statement
select * from scott.emp
Step 2.
give grant permission to all other users for the required objects(tables, views, stored procedures) in the following manner.
grant select, insert,update, delete on scott.emp to Test1;
grant select, insert,update, delete on scott.emp to Test2;
grant select, insert,update, delete on scott.emp to Test3;
Step 3.
Execute the reports by connecting with different users. No need to change the reports code.
Regards
Krishna Reddy M
VisualSoft Technologies
Hyderabad, India.
For example, if you are using emp table in scott user. meens emp table is created in scott user.
Step 1.
In your reports sql coding use the following sql statement
select * from scott.emp
Step 2.
give grant permission to all other users for the required objects(tables, views, stored procedures) in the following manner.
grant select, insert,update, delete on scott.emp to Test1;
grant select, insert,update, delete on scott.emp to Test2;
grant select, insert,update, delete on scott.emp to Test3;
Step 3.
Execute the reports by connecting with different users. No need to change the reports code.
Regards
Krishna Reddy M
VisualSoft Technologies
Hyderabad, India.
- Status
Similar threads