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

White LCD Display+Touch Screen Digitizer Assembly Replacement for iPhone 5S OEM
$13.99
White LCD Display+Touch Screen Digitizer Assembly Replacement for iPhone 5S OEM pictureLot of 2 Vintage Genuine OEM Nukote BM160 Ribbon Apple Imagewriter NEC PC8023A
$12.75
Lot of 2 Vintage Genuine OEM Nukote BM160 Ribbon Apple Imagewriter NEC PC8023A pictureOEM Apple iPhone Earphone
$4.36
OEM Apple iPhone Earphone pictureWhite LCD Display+Touch Screen Digitizer Assembly Replacement for iPhone5S OEM
$7.59
White LCD Display+Touch Screen Digitizer Assembly Replacement for iPhone5S OEM pictureCC8: Genuine OEM Apple Mac LONG DVI to VGA Video Adapter Cable 603-2120/591-011
$10.99
CC8:  Genuine OEM Apple Mac LONG DVI to VGA Video Adapter Cable 603-2120/591-011 picture






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