How to encrypt table name and column name in sql server?

Question

Hi All,

I know column data can be encrypted in sql server. But can anyone please help how can i encrypt table name and column name in sql server.

Thanks
Chirag

Answer 1

how can i encrypt table name and column name in sql server.

And what's that good for?

You can create views on the base table and in the view you can define cryptic alias name for the column to "obfuscated" their content/intent.
Grant the user only access on the views, but not on the base tables.

Answer 2

Hi @Chirag Sachdeva ,

> But can anyone please help how can i encrypt table name and column name in sql server.

Suggest you check if the suggestion from this similar thread How to encrypt Sql server table name and its column name & data inside for security pupose could help you.

---

If the response is helpful, please click "Accept Answer" and upvote it, thank you.