Wednesday, March 21, 2012

How to set writable property to readonly

Hi all,
Is there any command to change writable property of database or table or
column to readonly.
Thanks in advance.
SupriyaBelow links will be helpful
http://sqlblogcasts.com/blogs/tonyrogerson/archive/2007/08/26/how-to-make-a-table-read-only-in-sql-server.aspx
http://sqlblogcasts.com/blogs/tonyrogerson/archive/2007/08/27/read-only-file-group-tables-are-not-really-read-only-in-the-strict-sense.aspx
-
Shiju Samuel
On Sep 11, 1:56 pm, "Supriya Pagadala" <supriya_...@.yahoo.com> wrote:
> Hi all,
> Is there any command to change writable property of database or table or
> column to readonly.
> Thanks in advance.
> Supriya|||Hi Samuel,
Thanks for your response.I think you misunderstood the question.I want
to make particular property to readonly. Not entire table or database.
for example Table has following properties..
Name,NoOfColumns...etc.
If "Name" property is writable , how to make it read only?
"Shiju Samuel" <shiju.samuel@.gmail.com> wrote in message
news:1189502014.158301.151010@.y42g2000hsy.googlegroups.com...
> Below links will be helpful
> http://sqlblogcasts.com/blogs/tonyrogerson/archive/2007/08/26/how-to-make-a-table-read-only-in-sql-server.aspx
> http://sqlblogcasts.com/blogs/tonyrogerson/archive/2007/08/27/read-only-file-group-tables-are-not-really-read-only-in-the-strict-sense.aspx
> -
> Shiju Samuel
> On Sep 11, 1:56 pm, "Supriya Pagadala" <supriya_...@.yahoo.com> wrote:
>> Hi all,
>> Is there any command to change writable property of database or table
>> or
>> column to readonly.
>> Thanks in advance.
>> Supriya
>sql

No comments:

Post a Comment