Results 1 to 3 of 3
  1. #1
    Join Date
    Mar 2010

    Unanswered: Grant All Privileges for All Tables


    Is it possible to grant all privilege for an user, not only for one table but for all table?

    I have already use :
    grant all privileges on database 'mydatabase' to 'username' ;

    Of course, I can use the sybase to do it but it will make a lot of time

  2. #2
    Join Date
    Jan 2004
    Provided Answers: 4
    No. You can make the user an alias of DBA if you want this user to have all privileges (insert, select, create, drop, etcetera). If this is a repeated action, you can create a group in the database and grant all privileges manually once, and add users to that group when needed.
    I'm not crazy, I'm an aeroplane!

  3. #3
    Join Date
    May 2005
    South Africa
    Provided Answers: 1
    create and grant access to a group/role
    then all you have to do is add a user to the group/role

    take the output from this query and execute it
    select 'grant all on '+name+' to writergroup 
    go' from sysobjects where type='U'

Posting Permissions

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