BlackBerry Forums Support Community               

Closed Thread
 
LinkBack Thread Tools
Old 06-27-2008, 09:13 AM   #1 (permalink)
Thumbs Must Hurt
 
Join Date: Mar 2007
Location: London
Model: 8310
Carrier: O2 UK
Posts: 75
Post Thanks: 0
Thanked 0 Times in 0 Posts
Default Utterly confused with SQL permissions

Please Login to Remove!

All,

I'm managing to confuse the hell out of myself with SQL permissions and role-based administration. Can anyone give me a quick summary of the permissions needed, on SQL, for the following types of users? ::

1) The main BES admin login;
2) Members of a DL which will be given the "rim_db_admin_security" role;
3) Members of a DL which wil be given the "rim_db_admin_sr_helpdesk" role;

Our DBA is very keen to minimise the number of people with sa permissions, but I have no idea which people /need/ sa in the first place!

It's a minefield out there..

Cheers

Richard
Offline  
Old 06-27-2008, 09:54 AM   #2 (permalink)
BlackBerry Genius
 
hdawg's Avatar
 
Join Date: Aug 2006
Model: hdawg
PIN: port3101.org
Carrier: hdawg
Posts: 6,632
Post Thanks: 0
Thanked 0 Times in 0 Posts
Default

Quote:
1) The main BES admin login;
sysadmin role

Quote:
2) Members of a DL which will be given the "rim_db_admin_security" role;
rim_db_admin_security role

Quote:
3) Members of a DL which wil be given the "rim_db_admin_sr_helpdesk" role;
rim_db_admin_sr_helpdesk role
Offline  
Old 06-29-2008, 01:01 PM   #3 (permalink)
Thumbs Must Hurt
 
Join Date: Mar 2007
Location: London
Model: 8310
Carrier: O2 UK
Posts: 75
Post Thanks: 0
Thanked 0 Times in 0 Posts
Default

Thanks Hdawg.
Offline  
Closed Thread


Thread Tools

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

vB code is On
Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On

SYMBOL MOTOROLA MOTHERBOARD 128MB/128MB NON TOUCH WT4090 BARCODE SCANNER
$250.0
SYMBOL MOTOROLA MOTHERBOARD 128MB/128MB NON TOUCH WT4090  BARCODE SCANNER picture INTERMEC CN3 CN3BQH80000E400 WM61 EA11 MOTHERBOARD
$150.0
 INTERMEC CN3 CN3BQH80000E400 WM61 EA11 MOTHERBOARD  pictureGE VIVID I Ultrasound CPU Motherboard Card PN R2424349, R2423402
$1199.0
GE VIVID I Ultrasound CPU Motherboard Card PN R2424349, R2423402 pictureIwill VA133plus Motherboard W/ CPU Memory & INTEL SL4P2 CPU PGA370 SOCKET
$150.0
Iwill VA133plus Motherboard W/ CPU Memory & INTEL  SL4P2 CPU PGA370  SOCKET  picture10pack Panasonic 1200uf 6.3v 105c FC LOW ESR Top Quality Motherboard Capacitors
$5.29
10pack Panasonic 1200uf 6.3v 105c FC LOW ESR Top Quality Motherboard Capacitors picture






Copyright 2004-2016 BlackBerryForums.com.
The names RIM and BlackBerry are registered Trademarks of BlackBerry Inc.