SQL database access for specific records in a table(s)

[ghnat]

Sorry if this seems like a basic question ... I'm a newbie at SQL admin.

Running MSSQL 2000 on a win2k server with a database consisting of various linked tables having multiple customer information.

I would like to setup a user ID to have access to this database but only so they can view specific (their own customer data) records within the database tables.

I see the user table column access option in permissions but not for specific database records/rows?

ie ... If user ID is xxx then they can only see customer xxx records in the database!

Any assistance would be greatly appreciated

Thanks

ghnat

 

[JayKusch]

One way may be to create views and/or stored procedures that you grant access to based on the user. Of course this would mean that the records would have to have some unique ID or value that you could build the SPs or views on.

Thanks

J. Kusch

 

[mrdenny]

SQL does not support vertical permissions.

You need to use views and/or procs as Jay said.

Denny
MCSA (2003) / MCDBA (SQL 2000)

--Anything is possible. All it takes is a little research. (Me)

http://www.mrdenny.com

(My very old site)

 

[Catadmin]

Actually, Denny, SQL does support vertical permissions (columns). It just doesn't support horizontal (row) permissions unless you use a view or SP.

Except where Replication allows horizontal filtering.

@=)

Of course, I suspect that's what you meant in the first place but used the wrong word. @=)



Catadmin - MCDBA, MCSA
Beware the error of pre-emptive poultry inventory!

 

[mrdenny]

Your right. I used vertical instead of horizontal.

Vertical is supported, horizontal is not.

Denny
MCSA (2003) / MCDBA (SQL 2000)

--Anything is possible. All it takes is a little research. (Me)

http://www.mrdenny.com

(My very old site)