Application Development Discussions
Join the discussions or start your own on all things application development, including tools and APIs, programming models, and keeping your skills sharp.
cancel
Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Showing results for 
Search instead for 
Did you mean: 

Read only access to SD adn CO table - SAP on SQL 2005

corinne_lofts
Participant

‎12-17-2008 1:49 PM

0 Kudos

Hi everyone,

I need to set up access as read-only to our QAS SQL 2005 database for a consultant.

I want to restrict his access so that he can only read the SD and CO tables. I don't want himnear the HR and PY data especially.

The problem is I do not know who to pull the full list associated to SD and CO, can anyone give me direction?

Thank you

Coco

4 REPLIES 4

markus_doehr2
Active Contributor

‎12-17-2008 2:10 PM

0 Kudos

I suggest you ask that in the security forum, this is a pure permission/role/profile issue.

Markus

corinne_lofts
Participant
In response to markus_doehr2

‎12-17-2008 2:13 PM

0 Kudos

Will do, thanks.

corinne_lofts
Participant

‎12-17-2008 2:14 PM

0 Kudos

moved to security forum

Former Member
In response to corinne_lofts

‎12-17-2008 3:33 PM

0 Kudos

> 

> As far as I know the type of database does not matter.
> For restrictions you want to look at authorization groups. Not all tables are assigned to a group but the HR tables most likely are. Authorization object S_TABU_DIS can be a good search keyword in the forum.
> 
> Jurjen

.. and I agree with him and removed your second post.

Also keep an eye out for "&NC&" when searching.

Cheers,

Julius