Re: sql2k5 security

But what if I only wanted to give webuser permissions to execute stored
procedures and views and have no direct select,insert on the tables? This
used to work in SQL2000 right?


"Wei Lu" <weilu@xxxxxxxxxxxxxxxxxxxx> wrote in message
news:yIWWf93kGHA.4284@xxxxxxxxxxxxxxxxxxxxxxxx
Hi Param,

Thank you for using Microsoft MSDN Managed Newsgroup Support!

Would you please try to use the following statement to grant the
permission
for the login?

GRANT SELECT, INSERT ON dbo.table1 TO webuser

The GRANT will give the permission on the specified database object for
the
certain User.

Please refer the following article:

GRANT (Transact-SQL)

http://msdn2.microsoft.com/en-us/library/ms187965.aspx

Hope this will be helpful!

Sincerely,

Wei Lu
Microsoft Online Community Support

==================================================

When responding to posts, please "Reply to Group" via your newsreader so
that others may learn and benefit from your issue.

==================================================
This posting is provided "AS IS" with no warranties, and confers no
rights.



.

Relevant Pages

  • Re: sql2k5 security
    ... Thank you for using Microsoft MSDN Managed Newsgroup Support! ... Would you please try to use the following statement to grant the permission ... for the login? ...
    (microsoft.public.sqlserver.security)
  • Re: Allowing Anonymous write access only.
    ... need at least READ permission for login. ... > been set up so that anonymous FTP users have write access only, this> may seem insecure and we do get a certain ammount of hackers or> taggers testing the system by dropping test files and folders onto the> server, but because anonymous users do not have read access they soon> find that they cannot download anything they upload and go elsewhere. ... This is where my problems have started,> I initialy replicated all the IIS setting and NTFS permission from my> NT box on my 2003 box but so far have been unable to achive the same> result, it appaers that I can only grant anonymous write access if I ...
    (microsoft.public.inetserver.iis.ftp)
  • Re: Yukon schemas
    ... ALTER to the schema. ... you have to grant create permission to perform the action ... data and to create and alter stored procedures and views that they owned. ...
    (microsoft.public.sqlserver.security)
  • Re: Local admin right
    ... use Group Policy Restricted Groups to enforce membership of local computer ... > account to local admin group to run some applications. ... > used this permission to grant someone else to access that box too. ...
    (microsoft.public.security)
  • Re: AppArmor Security Goal
    ... permission to /home/$user/.mozilla...... ... and grant each user access to only ... two shell scripts (one to start each browser profile) and set the AA policy ...
    (Linux-Kernel)