Re: SELECT permission denied



In message <1146860360.589311.191390@xxxxxxxxxxxxxxxxxxxxxxxxxxxx>, Jens <Jens@xxxxxxxxxxxxxxxx> writes
Hi, then it seems that the login is also in another group which denies
the Select permission to that objects. Grant rights are communlative
but will be overwritten by any denying rights.

HTH, Jens Suessmeyer.

---
http://www.sqlserver2005.de
---


In addition, you may have granted DB Access to the new user but have your given the new user a minimum of "DataReader" rights under the Permissions tab.

--
Andrew D. Newbould E-Mail: newsgroups@xxxxxxxxxxxxxxxxx

ZAD Software Systems Web : www.zadsoft.com
.



Relevant Pages

  • Re: Unable to prevent OU deletion by Domain Admins?
    ... This posting is provided "AS IS" with no warranties, and confers no rights. ... >>>> It is even worse when Microsoft's own guidelines for parsing ACLs ... >>>> that DENY ACLs trump any allow ACLs ... >>> the list of permission entries in the DACL. ...
    (microsoft.public.win2000.active_directory)
  • Adding Roles With Selected Permission In Custom Add Role ASpx Page
    ... I have made a custom aspx form that lists down all the available permission ... rights for all groups in a Grid, and provides a text field for Site Group ... document libraries, edit Web discussion comments in documents, and customize ...
    (microsoft.public.sharepoint.portalserver.development)
  • RE: Need help understanding file rights
    ... > I'm having some trouble understanding how Windows server does file rights. ... > to their home directories only and still be able to backup the server. ... Let's make it short, you can set permission ...
    (microsoft.public.windows.server.general)
  • Thinking outside the box on file systems
    ... contains file data, name data, and permission data. ... files that you have some rights to and files where you ... The ACLs that were added to Linux were a step in the ... there would be mid level roles where users and objects ...
    (Linux-Kernel)
  • Re: Rec Bikes Techs other incarnation
    ... >> implies permission to distribute and copy the message in the regular ... There is not, so far as I have seen, a case which tests this Usenet limits, ... rights of privacy, and those writings can be used by the employer (parts of, ...
    (rec.bicycles.tech)

Loading