Professional Web Applications Themes

READ ONLY StoredProcedure - Microsoft SQL / MS SQL Server

Hi, How to create read only sp Dishan...

  1. #1

    Default READ ONLY StoredProcedure

    Hi,
    How to create read only sp
    Dishan


    Dishan Guest

  2. #2

    Default Re: READ ONLY StoredProcedure

    Hi Vinodk,
    Its something like system SPs.. Just Viewing.. cant editing
    Thanks for reply
    Dishan

    "Vinodk" <com> wrote in message
    news:#phx.gbl... 
    >
    >[/ref]


    Dishan Guest

  3. #3

    Default Re: READ ONLY StoredProcedure

    As far as I know, you can restrict the execute permission for a user defined
    SP by giving proper grants on the SP to a user. But I am not aware of making
    an user defined SP a view only one like your requirement ...

    --
    HTH,
    Vinod Kumar
    MCSE, DBA, MCAD
    www.extremeexperts.com


    "Dishan" <com> wrote in message
    news:e#ayM#phx.gbl... [/ref]
    only 
    > >
    > >[/ref]
    >
    >[/ref]


    Vinodk Guest

  4. #4

    Default Re: READ ONLY StoredProcedure

    Hi,
    So how do they create stored proc only for viwing and exec. cant be edit
    those..Can I do it with giving permission to other?

    for ex. msdb..sp_add_job
    regards
    Dishan


    "Vinodk" <com> wrote in message
    news:phx.gbl... 
    defined 
    making [/ref]
    > only 
    > >
    > >[/ref]
    >
    >[/ref]


    Dishan Guest

  5. #5

    Default Re: READ ONLY StoredProcedure

    Hi Dishan,

    You can create your stored procedures as system stored procedures using the
    undoented stored procedure sp_MS_upd_sysobj_category. The usage is as
    follows:

    EXEC master.dbo.sp_MS_upd_sysobj_category 1 -- Create procedure as system
    object
    GO
    CREATE PROCEDURE.......
    GO
    EXEC master.dbo.sp_MS_upd_sysobj_category 2 -- Back to normal
    GO

    All the usual terms and conditions for undoented stored procedures apply:
    you use at your own risk, it is not supported by Microsoft, and the
    behaviour and functionality can change with any Service Pack, hotfix or new
    version

    --
    Jacco Schalkwijk MCDBA, MCSD, MCSE
    Database Administrator
    Eurostop Ltd.


    "Dishan" <com> wrote in message
    news:phx.gbl... 
    > defined 
    > making [/ref][/ref]
    read 
    > >
    > >[/ref]
    >
    >[/ref]


    Jacco Guest

  6. #6

    Default Re: READ ONLY StoredProcedure

    Please don't multipost. I posted somewhere else, if you reply to that, I can elaborate.

    --
    Tibor Karaszi, SQL Server MVP
    Archive at: http://groups.google.com/groups?oi=djq&as ugroup=microsoft.public.sqlserver


    "Dishan" <com> wrote in message news:%phx.gbl... 


    Tibor Guest

Similar Threads

  1. Help: Program to read from EOR end of last read?
    By snoopy_@excite.com in forum Linux / Unix Administration
    Replies: 3
    Last Post: April 7th, 12:32 PM
  2. Dreamweaver PHP Extension that calls Oracle 8 storedprocedure?
    By sgerrard in forum Macromedia Exchange Dreamweaver Extensions
    Replies: 0
    Last Post: December 29th, 07:08 PM
  3. File system get auto change from read-write to read-oly
    By RC in forum Linux / Unix Administration
    Replies: 1
    Last Post: October 23rd, 10:51 PM
  4. Read & Read/Write Groups
    By Damien Harrod in forum Sun Solaris
    Replies: 1
    Last Post: July 22nd, 01:52 PM
  5. StoredProcedure and View
    By Bahman Lashgari in forum Microsoft SQL / MS SQL Server
    Replies: 2
    Last Post: July 1st, 11:26 PM

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  

1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 36 37 38 39 40 41 42 43 44 45 46 47 48 49 50 51 52 53 54 55 56 57 58 59 60 61 62 63 64 65 66 67 68 69 70 71 72 73 74 75 76 77 78 79 80 81 82 83 84 85 86 87 88 89 90 91 92 93 94 95 96 97 98 99 100 101 102 103 104 105 106 107 108 109 110 111 112 113 114 115 116 117 118 119 120 121 122 123 124 125 126 127 128 129 130 131 132 133 134 135 136 137 138 139