RE: DETAILS SOUGHT: Renaming this user-defined function removes any existing permissions and extended properties.

• Previous message: Jason: "Re: AutoNumber feild"
• In reply to: Malcolm Cook: "DETAILS SOUGHT: Renaming this user-defined function removes any existing permissions and extended properties."
• Messages sorted by: [ date ] [ thread ]

Date: Mon, 28 Jun 2004 23:14:25 GMT

Hi, Malcolm

I'll need to research this issue.. Can you confirm that you see the same
behavior on the nwind database?

Thanks,

John Eikanger
Microsoft Developer Support

This posting is provided “AS IS” with no warranties, and confers no rights.
--------------------
| From: "Malcolm Cook" <mec@stowers-institute.org>
| Subject: DETAILS SOUGHT: Renaming this user-defined function removes any
existing permissions and extended properties.
| Date: Sun, 27 Jun 2004 02:49:41 -0500
| X-Tomcat-NG: microsoft.public.access.adp.sqlserver
|
| H'lo,
|
| When developing an ADP, renaming a user defined function using ACC2002
front
| end against SQL Server 2000, you get prompted with:
|
| Renaming this user-defined function removes any existing permissions
| and extended properties.
|
| I find that it does NOT in fact alter the existing permissions; rather,
any
| grants made in SQL Server survive the rename. At least in my minimal
| testing.
|
| However, as warned, extended properties are wiped.
|
| Dooh!
|
| Why is this? I wonder, because, when I simply use sp_rename directly in
SQL
| Server, there is no loss of expended properties (nor permissions).
|
| I also wonder what effect I might expect this to have on Access. There
are
| a bunch of expended properties that Access uses for something, but this is
| not documented anywhere. They all begin with MS_. It makes me leery.
|
| The lesson, I think, is just use sp_rename on the server. However, maybe
MS
| WANTS the extended properties wiped. Maybe allowing them to survive a
| rename such as happens using sp_rename will bollix up Access somehow else,
| and that is why renaming them through the Access UI trashes these
| properties... on pupose.
|
| Who knows? Is this right?
|
| I care because I sometimes need to rename UDFs and I use my own extended
| properties on them.... so I need to make sure I 'm doing this "right".
|
| Any knowledge on this out there?
|
| Thanks!
|
| --
| Malcolm Cook - mec@stowers-institute.org
| Database Applications Manager - Bioinformatics
| Stowers Institute for Medical Research - Kansas City, MO USA
|
|
|

• Previous message: Jason: "Re: AutoNumber feild"
• In reply to: Malcolm Cook: "DETAILS SOUGHT: Renaming this user-defined function removes any existing permissions and extended properties."
• Messages sorted by: [ date ] [ thread ]