Re:column level permissions

From: Vishal Parkar (vgparkar@hotmail.com)
Date: 02/18/03 

From: "Vishal Parkar" <vgparkar@hotmail.com>
Date: Tue, 18 Feb 2003 10:36:37 -0800

If you want assign permission only to insert into specific
columns you can create a view with the required columns
and grant insert permission on that view to users. Make
sure all other columns are nullable or if they have not
null constraints on it then has some default values.

--Vishal.

>-----Original Message-----
>Users on a database want to be able to write to one
>specific column in a table that they currently only have
>read access. How would I give them permissions to just
>that column, without give write permissions to the whole
>table? Do I use the GRANT statement?
>
>Thanks,
>Rick
>.
>

Relevant Pages

  • 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)
  • RE: Share Issues
    ... Where are the others shares located, in the old domain or new win2k3 ... How do you grant the permission to the "other shares", ... Microsoft Active Directory: Demo 3-Security Translation Wizard ...
    (microsoft.public.windows.server.migration)