Re: [Virtuoso-users] Delete all default users

[Hugh Williams]

Hi Nauman,

This is the list of default users created Virtuoso:

SQL> select U_NAME from sys_users where U_IS_ROLE =0;
U_NAME
VARCHAR NOT NULL
___

PKI
PROXY
SIMILE
SPARQL
SPARQL_ADMIN
WEBID_API
WebMeta
XMLA
__rdf_repl
dav
dba
nobody

12 Rows. -- 1 msec.
SQL> 

The “dba” , “dav” users should not be removed as these are Admin user accounts  
... the “SPARQL” , “SPARQL_ADMIN” accounts are special accounts required for 
SPARQL/RDF  access  ... the other users accounts I doubt are required ... still 
not sure why you want to delete all users from a default installation ?

Best Regards
Hugh Williams
Professional Services
OpenLink Software, Inc.  //  http://www.openlinksw.com/
Weblog   -- http://www.openlinksw.com/blogs/
LinkedIn -- http://www.linkedin.com/company/openlink-software/
Twitter  -- http://twitter.com/OpenLink
Google+  -- http://plus.google.com/100570109519069333827/
Facebook -- http://www.facebook.com/OpenLinkSoftware
Universal Data Access, Integration, and Management Technology Providers



> On 31 Jul 2018, at 18:01, Nauman Ramzan  wrote:
> 
> Thank you hugh william, i wanted to ask that will there be any problem if i 
> will remove all users ( except dba ) ? Or any user which is for internal use ?
> Thank you
> 
> On Tue, Jul 31, 2018 at 7:43 PM Hugh Williams  > wrote:
> Hi Nauman,
> 
> Virtuoso has a user_drop() function as detailed at:
> 
> http://docs.openlinksw.com/virtuoso/fn_user_drop/ 
> 
> 
> Or you can delete them via the Conductor  “System Admin” -> “User Accounts” 
> tab ...
> 
> Note the special “dba” Administrative user account cannot be deleted ...
> 
> Best Regards
> Hugh Williams
> Professional Services
> OpenLink Software, Inc.  //  http://www.openlinksw.com/ 
> 
> Weblog   -- http://www.openlinksw.com/blogs/ 
> 
> LinkedIn -- http://www.linkedin.com/company/openlink-software/ 
> 
> Twitter  -- http://twitter.com/OpenLink 
> Google+  -- http://plus.google.com/100570109519069333827/ 
> 
> Facebook -- http://www.facebook.com/OpenLinkSoftware 
> 
> Universal Data Access, Integration, and Management Technology Providers
> 
> 
> 
> > On 11 Jul 2018, at 20:14, Nauman Ramzan  > > wrote:
> > 
> > Hi i have one small question is this possible to remove all default users 
> > from virtuoso so that i dont need to take care of others accounts I will 
> > create my own new user ? 
> > Thank you
> > --
> > Check out the vibrant tech community on one of the world's most
> > engaging tech sites, Slashdot.org! 
> > http://sdm.link/slashdot___ 
> > 
> > Virtuoso-users mailing list
> > Virtuoso-users@lists.sourceforge.net 
> > 
> > https://lists.sourceforge.net/lists/listinfo/virtuoso-users 
> > 
> 

--
Check out the vibrant tech community on one of the world's most
engaging tech sites, Slashdot.org! http://sdm.link/slashdot___
Virtuoso-users mailing list
Virtuoso-users@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/virtuoso-users

Re: [Virtuoso-users] Delete all default users

[Hugh Williams]

Hi Nauman,

Virtuoso has a user_drop() function as detailed at:

http://docs.openlinksw.com/virtuoso/fn_user_drop/

Or you can delete them via the Conductor  “System Admin” -> “User Accounts” tab 
...

Note the special “dba” Administrative user account cannot be deleted ...

Best Regards
Hugh Williams
Professional Services
OpenLink Software, Inc.  //  http://www.openlinksw.com/
Weblog   -- http://www.openlinksw.com/blogs/
LinkedIn -- http://www.linkedin.com/company/openlink-software/
Twitter  -- http://twitter.com/OpenLink
Google+  -- http://plus.google.com/100570109519069333827/
Facebook -- http://www.facebook.com/OpenLinkSoftware
Universal Data Access, Integration, and Management Technology Providers



> On 11 Jul 2018, at 20:14, Nauman Ramzan  wrote:
> 
> Hi i have one small question is this possible to remove all default users 
> from virtuoso so that i dont need to take care of others accounts I will 
> create my own new user ? 
> Thank you
> --
> Check out the vibrant tech community on one of the world's most
> engaging tech sites, Slashdot.org! 
> http://sdm.link/slashdot___
> Virtuoso-users mailing list
> Virtuoso-users@lists.sourceforge.net
> https://lists.sourceforge.net/lists/listinfo/virtuoso-users


--
Check out the vibrant tech community on one of the world's most
engaging tech sites, Slashdot.org! http://sdm.link/slashdot
___
Virtuoso-users mailing list
Virtuoso-users@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/virtuoso-users

[Virtuoso-users] Delete all default users

[Nauman Ramzan]

Hi i have one small question is this possible to remove all default users
from virtuoso so that i dont need to take care of others accounts I will
create my own new user ?
Thank you
--
Check out the vibrant tech community on one of the world's most
engaging tech sites, Slashdot.org! http://sdm.link/slashdot___
Virtuoso-users mailing list
Virtuoso-users@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/virtuoso-users