Lock the Tables

[SQLBaby]

Is any way to lock the table so no body can open and see the contents of table and data... also if some body lock the table, how we can open the table, at last how we can see the fields name, size etc

Knowledge is a key of success.

 

[Corran007]

I assume you are talking about financial or hr information that is being put in a table and the powers that be dont trust the programmers/dba with the information.

you can deny access to that table easily enough, however anyone wity sysadm level will be able to see it. You should be using views so no on sees the actual table anyhow.

you need to explain to them that the dbas will need access to the information to do your job. In dev and test enviorments, use dummy data for the table, or alter the info that can be used to identify a person with the information. In production, restrict access to the DBA's. remove permissions for everyone else to that table. Get a nice round of non discloser agreements and give them out to everyone to sign. If they dont trust the programmers/dbas they need to get new programmers/dbas who they can trust. if they trust no one, tell them they cannot have it.

At my company i am the dba. I have full access to all data in the sytem including hr, payroll, budget and a bunch of other things. i go a very long nda that i had to sign. They trust me knowing i wont speak about the info expect with those who already know it. If they could not trust me anymore, they would get someone else who they could.

 

[SQLBaby]

Corran007 ... thanks for your reply, wel its little in detail, i have sysadmin previlages. I have access all tables and DB's even in Prod, HR or test.. all. Now we have one software for Accounts call Navission Attain, we are paying alot to them for a little change, now we decided to transfer/convert that database in SQL 2K and again we are paying lot for that. i am affraid after convertion in sql if still we are not able to se the tables then what the other way to open the tables. Then at least we can desighn and write code for our requirement in VB etc...

i hope you understand now what i need

Knowledge is a key of success.

 

[Corran007]

ok, bit different than i thought.

if you have sysadm privges, you will be able to see inside the table/see its design once in sql server.

They will not be able to prevent you from doing so. if they somehow manage to remove the privalges necessary, just add them back.

 

[SQLBaby]

Ok, Thanks for these info

Knowledge is a key of success.

 

[flstffatboy]

SQLBaby,

I'm not familiar with Navision Attain but we are currently implementing Navision Axapta (complete mid-size ERP solution). We are running it on SQL Server 2000 and one thing I do not like about the product is that all the table relations exist at the Aplication layer. I cannot make any sense of the tables at the database level as far as relations go.

I'm not sure if Attain is similar but if it is it could cause you developing nightmares because you cannot see how the tables are related unless you have access to certain layers in the application.

Just my 2 cents
FLSTF

 

[jawan]

Yes you are right, you know they put lot checks on tables, reports every where, if we try to change we got message access denied at the time when we try to save the changes. and when we talk Navision they charge lot of money, now the problem is my compnay has almost 10 years accounts data in Navision. And we are stuck with them, now i am trying to solve this matter.
This navision website is

http://www.astongroup-us.com

is it yours too...?

 

[jawan]

By the way, as SQLbay mentioned, can we do write the codes on those tables, if we create new relation, what will happen in Navisions relation, i think we can see the relation in SQL Enterprise Manager. am i write...?

 

[SQLBaby]

Happysmile, yes we are using same software from astongroup.

flstffatboy, do you use the same software from astongroup....?

Knowledge is a key of success.