Results 1 to 3 of 3

Thread: permission limit

  1. #1
    Alex Guest

    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

  2. #2
    Todd Guest

    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

  3. #3
    Alex Guest

    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
  •