Post reply

Give datareader role create priveleges?

  • September 10, 2007 at 9:36 am

    #180948

    Is there way to give an account that is read-only i.e. datareader role the ability to create temp tables that can be used for reports? Basically we have a situation where the report columns need to be dynamically generated and the developer wants to do this via temp tables.

    Is there a better way to approach this issue for creating dynamic reports based on input parameters?

  • September 10, 2007 at 12:02 pm

    #732575

    you are thinking about it wrong...you should create a new role that has db_datareader writes, and then any additional rights you want toa dd. don't try to change the existing system roles.

    Also, I belive every login has read rights to master, and read/write to temp by default. Are you sure that's what the issue is? maybe your login doesn't have execute rights to teh stored procedure that would be creating these temp tables. We might need an example of what you are trying to do.

     

    Lowell

    --help us help you! If you post a question, make sure you include a CREATE TABLE... statement and INSERT INTO... statement into that table to give the volunteers here representative data. with your description of the problem, we can provide a tested, verifiable solution to your question! asking the question the right way gets you a tested answer the fastest way possible!

Viewing 2 posts - 1 through 1 (of 1 total)

You must be logged in to reply to this topic. Login to reply