Virtual Private Databases 
Author Message
 Virtual Private Databases

Hello,

Can anybody offer me some pointers as the security functionality of MS
SQL Server.

Currently I am using an Oracle platform, and am planning to impliment
the Oracle 8i security feature - Virtual Private Database. This feature
allows secuirty rules to be set up depending say upon the username, and
then allows for row level security by adding additional WHERE statements
to all SQL operations carried out against a given table.

So if you had as an example a SHIPPING_ORDER table, that you allowed
customers read access to, the user name could be used to restrict the
rows of the table they could read to data about their orders only.

Can MS SQLServer2000 duplicate this functionality?????????

May thanks in advance,

Aidan



Tue, 20 May 2003 03:00:00 GMT
 Virtual Private Databases

You can assign user permissions to the column level in SQL Server.  Views
can be used to horizontally filter data and permissions to the views control
who can see different sets of rows, stored procedures could be used for this
too.


Tue, 20 May 2003 03:00:00 GMT
 
 [ 2 post ] 

 Relevant Pages 

1. Virtual Private Database

2. Virtual Private Database

3. Row-based security (virtual private database)

4. Virtual Private Database

5. Virtual Private Databases and DB Pooling

6. Virtual Private Database

7. Virtual Private Databases

8. Virtual Private Databases and DB Pooling

9. Virtual Cube - Private Dimension

10. Virtual Private Router for SqlServer

11. Replication over VPN(Virtual Private Network)

12. PostgreSQL friendly ISP w/ Virtual Private Server


 
Powered by phpBB® Forum Software