RE: Can user view objects they only have select permission on?

Here's the commands that I'm executing in order:

CREATE ROLE [Customers_ROLE] Authorization dbo
CREATE SCHEMA [Customers_Schema] AUTHORIZATION [Customers_Role] Deny View
Definition to [Customers_Role]
exec sp_adduser 'phenson', 'phenson', [Customers_Role]
GRANT SELECT ON [dbo].[PT_VIEW] TO [Customers_Role]


When I log in as phenson I do not see PT_View but I can query on it. I need
to be able to see it.

"SpankyATL" wrote:

I have a user that belongs to a role. This role only has select permissions
on 10 views. When I log in as this user via Management Studio I cannot see
the views however I can execute queries against them.

On another server that I did not setup, that I'm supposed to be mimicking
the same security, this same user can see the views.

Any ideas what the difference is?

Thanks!
.

Relevant Pages

  • Re: Searching for Robust Download Automation
    ... to execute a command upon successful transfer. ... ad hoc methods for detecting corrupted/incomplete files, executing ... those commands, and cleaning out the transferred files. ... UUCP has done the things I list above for 20+ years, ...
    (comp.unix.shell)
  • Makeinfo error when attempting to compile binutils-2.18 for AVR target
    ... I'm trying to compile the gnu avr toolchain on Fedora 7. ... config.status: executing depfiles commands ...
    (Fedora)
  • Re: remove user exe execute permission
    ... The only way I can think of to prevent a user from executing commands is to ... needs to be able to call CreateProcess* to successfully run CGI Scripts on ... >> full control under their IIS web folder to their files. ...
    (microsoft.public.windows.server.security)
  • Re: source question
    ... > currently executing using the 'info script' command. ... some main commands ... some filea commands ...
    (comp.lang.tcl)
  • Re: echo commands
    ... The shell script when executed doesn't echo the ... > commands it is executing. ... How to make it echo the commands it ... I will have to modify it in two places. ...
    (comp.unix.shell)