
|
Manage Email Signatures Centrally - For All Users extend your brand and promote your products, services, special events and news
|
| View previous topic :: View next topic |
| Author |
Message |
Jesper Frier Certified Professional


Joined: 09 Sep 2006 Posts: 1940 Location: Stoevring, Denmark
|
| Posted: Fri Dec 29, 2006 3:35 pm Post subject: SQL 2005 DB permissions not described |
|
|
Permissions not described in deployment guide found in HELP ME! menu in Cockpit.
MS SQL 2000.
MS SQL 2005 - missing.
As SQL is now the recommended DB due to intensive logging, this is important to describe in detail or automate.
Last edited by Jesper Frier on Tue Jul 24, 2007 7:46 am; edited 5 times in total |
|
| Back to top |
|
 |
Jesper Frier Certified Professional


Joined: 09 Sep 2006 Posts: 1940 Location: Stoevring, Denmark
|
| Posted: Fri Jan 05, 2007 11:14 pm Post subject: Tak for input fra Tommy ... |
|
|
Tak for input Tommy ...
| Quote: | Vedr. rettigheder på tabellerne, så er her syntaxen til SQL scriptet:
GRANT { { SELECT | INSERT | UPDATE | DELETE | RULE | REFERENCES | TRIGGER }
[,...] | ALL [ PRIVILEGES ] }
ON [ TABLE ] tablename [, ...]
TO { username | GROUP groupname | PUBLIC } [, ...]
Man kunne så definere en admin samt en user bruger som en variabel i starten af scriptet, så det var let for jeres kunder at modificere scriptet. |
|
|
| Back to top |
|
 |
Bjarne Mess Certified Professional


Joined: 01 May 2007 Posts: 735 Location: Copenhagen
|
|
| Back to top |
|
 |
|
|
You cannot post new topics in this forum You cannot reply to topics in this forum You cannot edit your posts in this forum You cannot delete your posts in this forum You cannot vote in polls in this forum
|
|