I am trying to protect some data in a database. I set up security on the appropiate database. Users who didn't received the appropiate rights cannot access data in certain tables anymore. So far so good. However, when such a user creates another database, creates a table in it with exact the same DDL as the table he isn't suppose to access by not having the appropiate rights and if this users points the filepath of this table to the same file as the one in the other database, the user can perfectly access this table. So the security is not built in the individual files of each table as I experience. Anyone solved this problem to avoid that users can do this to access data they aren't supposed to access?
Tek-Tips is the largest IT community on the Internet today!
Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!
-
Congratulations IamaSherpa on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
Protecting data
- Thread starter Patten
- Start date
Similar threads
- Locked
- Question
- Locked
- Question