|
<?xml version="1.0" encoding="utf-8" ?>
<configuration>
<configSections>
<sectionGroup name="userSettings" type="System.Configuration.UserSettingsGroup, System, Version=2.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089" >
<section name="JocysCom.Sql.ScriptsGenerator.Properties.Settings" type="System.Configuration.ClientSettingsSection, System, Version=2.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089" allowExeDefinition="MachineToLocalUser" requirePermission="false" />
</sectionGroup>
</configSections>
<userSettings>
<JocysCom.Sql.ScriptsGenerator.Properties.Settings>
<setting name="PermissionTextBox" serializeAs="String">
<value>---------------------------------------------------------------
-- Grant Permission To All Stored Procedures
---------------------------------------------------------------
-- Grant execute permission on procedures to user.
DECLARE @user sysname SET @user = 'UserName'
DECLARE @item nvarchar(128)
DECLARE items CURSOR LOCAL FAST_FORWARD READ_ONLY FOR
-- Put SQL String here to select item value from table.
SELECT [name] FROM sysobjects WHERE [type] = 'P' and [category] = 0 ORDER BY [name]
OPEN items
FETCH NEXT FROM items INTO @item
WHILE (@@fetch_status <> -1)
BEGIN
IF (@@fetch_status <> -2)
BEGIN
-- Do some action with item value.
EXEC('GRANT EXECUTE ON ['+@item+'] TO ['+@user+']')
END
FETCH NEXT FROM items INTO @item
END
DEALLOCATE items</value>
</setting>
<setting name="XcetSourceTextBox" serializeAs="String">
<value>--- <summary>
--- Insert new record into table.
--- </summary>
--- <param name="RecordId">Unique record Id.</param>
--- <param name="RecordGuid">Set Global Unique Identifier.</param>
--- <param name="SomeValue">Set record value.</param>
--- <param name="RecordEnabled">Enable or disable record.</param>
--- <returns>Unique Id of new record.</returns>
--- <remarks>
--- History:
--- 2007-11-02 - Created by Smith.
--- 2007-11-23 - Modified by Neo.
--- </remarks>
CREATE PROCEDURE [dbo].[solution_Category_InsertRecord] (
@RecordId Int,
@RecordGuid UniqueIdentifier,
@SomeValue NVarChar(200),
@RecordEnabled Bit
)
AS
-- Stored procedure starts here...
--- ----------------------------
--------------------------------</value>
</setting>
<setting name="XcetRegExTextBox" serializeAs="String">
<value />
</setting>
</JocysCom.Sql.ScriptsGenerator.Properties.Settings>
</userSettings>
</configuration>
|
By viewing downloads associated with this article you agree to the Terms of Service and the article's licence.
If a file you wish to view isn't highlighted, and is a text file (not binary), please
let us know and we'll add colourisation support for it.
This member has not yet provided a Biography. Assume it's interesting and varied, and probably something to do with programming.