Re: Rich Client and Windows Authentication

From: Tom (someone@nobody.com)
Date: 11/25/02 

From: "Tom" <someone@nobody.com>
Date: Mon, 25 Nov 2002 19:41:48 +0100

Hi Pablo,

> You can do this behavior using views or stored
> procedures... I think is better using sp because you can
> easily use the system function USER_NAME() before you
> access the table to manage the permissions to see the data.
> Doing this, you need the user have only permission to exec
> the stored procedure and no need select grant on the table.

I think I'll opt for permitting them to execute a stored procedure. Views
would be difficult since there's over a thousand users. There are three
types of users, so I'll just set up stored procedures with different owners

    Owner1.GetReports
    Owner2.GetReports
    Owner3.GetReports

and keep the logic in there. Yep! Thanks for your response! :-)

Tom

Relevant Pages

  • Solaris 10 autofs directory permissions - Solution
    ... the fact that my map file has 755 permissions not 644. ... If the execute permission is set, it becomes an executable map which is ... map is expected to return the content of an automounter map ...
    (SunManagers)
  • Re: Rights to execute jobs?
    ... Does anyone know if the rules surrounding stored procedure permissions apply ... Does this apply to a proc calling sp_start_job so that I ... raise the alert, so it could be anyone on the server. ... is that a group needs to not be an admin but still be able to execute ...
    (microsoft.public.sqlserver.security)
  • Re: Newbie
    ... I will now tell you some basic commands. ... Easy file has rights and a owner. ... file and who may execute it. ... The last three characters are about the permissions of user ...
    (alt.linux)
  • Re: Execute Persmission denied on object sp_OACreate
    ... SQL Server doesn't check permissions on indirectly referenced objects as ... You can prevent ad-hoc execution of powerful master database procs while ... >I have a user who has execute permissions on a store procedure in a>database> which in turns executes 4 stored procedures in the master database. ...
    (microsoft.public.sqlserver.security)
  • Re: remove user exe execute permission
    ... be able to read or execute the file. ... In NTFS grant - read and execute ... remove the 'read' permission of that folder. ...
    (microsoft.public.windows.server.security)