-
permission limit
hello everybody
I created user "MyUser " with rights
1. public for database "Orders"
2. select, update,delete, insert to table Orders.dbo.PersonalInfo
I have table Orders.dbo.PersonalInfoChangeLog
( it keeps information on any update on Orders.dbo.PersonalInfo including
HOST_NAME())
So I don't want anybody to see even structure of this table(Orders.dbo.PersonalInfo ).
if person loged as "Myuser" he can use
1. sp_help PersonalInfoChangeLog
2.Enterpise Manager to see properties of the table
How can limit rights to see structure without generating Application role ?
Thanks
-
permission limit (reply)
I think you can do the following:
Don't give permissions on Orders.dbo.PersonalInfo. Create a view Orders.dbo.PersonalInfo_View and give rights to it instead. Don't include the sensitive material in the view.
------------
Alex at 7/13/01 12:32:06 PM
hello everybody
I created user "MyUser " with rights
1. public for database "Orders"
2. select, update,delete, insert to table Orders.dbo.PersonalInfo
I have table Orders.dbo.PersonalInfoChangeLog
( it keeps information on any update on Orders.dbo.PersonalInfo including
HOST_NAME())
So I don't want anybody to see even structure of this table(Orders.dbo.PersonalInfo ).
if person loged as "Myuser" he can use
1. sp_help PersonalInfoChangeLog
2.Enterpise Manager to see properties of the table
How can limit rights to see structure without generating Application role ?
Thanks
-
permission limit (reply)
thank a lot quick answer
I sorry I made mistake in my question.
I want to
1. restrict access to propreties of table Orders.dbo.PersonalInfoChangeLog
from EM.
2. restrict usage of sp_help PersonalInfoChangeLog
I am sorry for confusion.
Thanks
------------
Todd at 7/13/01 3:35:25 PM
I think you can do the following:
Don't give permissions on Orders.dbo.PersonalInfo. Create a view Orders.dbo.PersonalInfo_View and give rights to it instead. Don't include the sensitive material in the view.
------------
Alex at 7/13/01 12:32:06 PM
hello everybody
I created user "MyUser " with rights
1. public for database "Orders"
2. select, update,delete, insert to table Orders.dbo.PersonalInfo
I have table Orders.dbo.PersonalInfoChangeLog
( it keeps information on any update on Orders.dbo.PersonalInfo including
HOST_NAME())
So I don't want anybody to see even structure of this table(Orders.dbo.PersonalInfo ).
if person loged as "Myuser" he can use
1. sp_help PersonalInfoChangeLog
2.Enterpise Manager to see properties of the table
How can limit rights to see structure without generating Application role ?
Thanks
Posting Permissions
- You may not post new threads
- You may not post replies
- You may not post attachments
- You may not edit your posts
-
Forum Rules
|
|