Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 
        
Home       Members    Calendar    Who's On


Add to briefcase

can we give a copy of a database to someone and it be packaged in such a way so that they cannot see the table structure / design? Expand / Collapse
Author
Message
Posted Friday, April 19, 2013 3:24 AM
SSC Rookie

SSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC Rookie

Group: General Forum Members
Last Login: Thursday, November 28, 2013 1:34 AM
Points: 27, Visits: 157
can we give a copy of a database to someone and it be packaged in such a way so that they cannot see the table structure / design????????

Thanks in advance,

suresh.
Post #1444288
Posted Friday, April 19, 2013 3:48 AM


SSC-Forever

SSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-Forever

Group: General Forum Members
Last Login: Yesterday @ 11:52 AM
Points: 41,530, Visits: 34,446
No.

Give someone a database and you're giving them full and complete control over the schema and data.



Gail Shaw
Microsoft Certified Master: SQL Server 2008, MVP
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability

We walk in the dark places no others will enter
We stand on the bridge and no one may pass

Post #1444293
Posted Wednesday, April 24, 2013 10:18 AM
Old Hand

Old HandOld HandOld HandOld HandOld HandOld HandOld HandOld Hand

Group: General Forum Members
Last Login: Monday, April 14, 2014 11:32 AM
Points: 306, Visits: 533
What are you trying to achieve Suresh?

Even if you provided all of the data in .csv files or in a massive Excel spreadsheet the person will still be able to see the layout of the tables, although they wouldn't be able to see any of the key relationships, triggers, indexes, stored procedures etc...


SQL SERVER Central Forum Etiquette
Post #1446106
« Prev Topic | Next Topic »

Add to briefcase

Permissions Expand / Collapse